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!