1 of 1 people found this helpful
Although you have only 4 products, you may want to think beyond just 4.
Contacts (customers etc)
Central layout is your Orders. You could have a drop down of clients and a portal of Order Items/Invoice Items
Within the portal of items, you would have your Product (drop down of your products), Qty, etc...
I hope this helps?
Yes, take a step back.
I would recommend creating an ERD. When you draw the database and list fields in an organized way, you create the ability to communicate your design with managers, team members, other stakeholders. And, aside from being able to then understand (and modify as you go) what you're trying to do yourself, you can post that diagram here for input.
I use an inexpensive tool called SQL Editor.
SQL Editor will let you visually design your FMP database and then it WILL CREATE YOUR FMP DATABASE FOR YOU IN FMP!
Don't mistake the Relationship graph for an ERD tool.
HOPE THIS HELPS.