I'm developing a system for my company and while trying to desing an invoice table I can't seem to be able to enter each of the items in a separate field. My current tables are Customers, Items and Invoices. I presume I made the correct relationships between them but the thing is that i want to be able to enter in the actual invoice each item separately and it doesn't let me cause if I add another field for item it enters the same item previously entered. Can anyone pinpoint me where am I going wrong?
Thank you very much!
You need more than one table and relationships to link them. Your items purchased then are entered into multiple rows of this portal.
The Invoices starter solution is built on this structure. So is this much simpler demo file created by Comment: http://fmforums.com/forum/showpost.php?post/309136/