I am new to FileMaker. I am in the process of creating my first solution. It is basically a database for a sports lounge. It tracks what they buy to eat or drink. Also if they want to play the sports they offer there.
I have the products they sell in different tables. Such as; beverages in one table, food in one table, hookah in one table and so on.
Each product table has a bill_id field. I have a Table Page that generates a Bill # which relates to the product tables::bill_id
On the Table page, I have portals setup for each product so they can choose the product and it would calculate the price based on quantity.
This shows the workers how much each bill has spent.
Although I have the amount they spent on each product on the Table Page, I would like to make a type of list on the side that shows each thing they have bought. Kind of like a receipt. I tried to do this with a portal that would filter out if productName>"" but I cannot add different products as they are on different tables.
I'm not sure what direction to take as I am fairly new to FMP.
*Note: I have attached a pic of the layout in question