AnsweredAssumed Answered

relationship setup question

Question asked by natwroy on Feb 10, 2010
Latest reply on Feb 11, 2010 by philmodjunk


relationship setup question


I am using filemaker 10 advanced on a mac and I am a new user. I am wondering how I should properly setup the relationships for my database. I have customers and tests that I provide for them. For example I have 100 customers and 50 possible tests that they could take. Each customer is charged a different price for each of the 50 tests based on the contract they make. I was thinking I would have a one to many relationship from a table named customer to a table named test_price, and also a one to many relationship from test to test_price. Is this the right way to go? Will this cause problems when I try to create my invoicing, and how should I setup the relationship from test_price to invoice.