AnsweredAssumed Answered

Help needed with tables and relationships

Question asked by AshleyEvans on Jul 12, 2011
Latest reply on Sep 1, 2011 by AshleyEvans

Title

Help needed with tables and relationships

Post

Hi Guys,

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?

http://s205.photobucket.com/albums/bb47/alderevans2007/?action=view&current=Tables.jpg

Thank you very much!

Outcomes