Help needed with tables and relationships
I am new to filemaker and am creating a database for my business. Our business involves selling cab glass for heavy machinery (jcb's etc)
Every manufacturer and model of machine has it's own record in the "Machine Models" table. Every machine has only one cab, but one cab can fit many machines. Each cab is made up of up to 10 pieces of glass (items). One piece of glass (item) can fit multiple cabs.
Before I go any further and import every item, could somebody tell me if this is an efficient way of organising the tables?
Thank you very much!