I have a standard invoice database with Invoice, Invoice Data, Products table. I have added a child table named Button to the product table (related by ProductID)that is used to create buttons in portals on the invoice table. The Button table has a product match field, a column field, a category field and a sub category field. Each of these fields are used to filter portals on the invoice layout. It places "Buttons" on the layout that allows me to add products to the invoice. Each product can have multiple button records. Each of these records should place the product anywhere I choose in any of the portals on the invoice layout. The portals on the layout are filtered by Column, (designates which portal it will show up in)Category equated to a variable and subcategory equated to a variable. Each of the variables are created by a layout button that sets each variable according to the category/subcategory that I choose. It works quite well with one exception it only shows the first record of the button table that exists for each product. Hard to explain, but I can supply more info if necessary.

Powered by WPeMatico