My first post and my first advanced challenge that I need feedback on. I am new to filemaker and working with the inventory starter solution in FM 11. I have created a few new table for sales, expenses, events, so that I can track those items. On the sales layout I have the date, location ammount etc.. What I would like to add is a list of items that i can show were sold at a specific event. It seems like a portal would be the way to go. I simply want a to be able to choose specific inventory items that were sold and list those items. Later on I would like to have it update the inventory if something was sold but right now i just want to display a list that pulls from inventory.
Can anyone send me in the right direction as far as how to form the relationship and what type of control is used for this type of scenario.
Thanks for any feedback,