AnsweredAssumed Answered

What is the difference between these table relationship

Question asked by starstuff on May 15, 2015
Latest reply on May 18, 2015 by starstuff

Title

What is the difference between these table relationship

Post

Hi all!

i'm testing out filemaker as a suitable replacement for the multiple spreadsheets i use. i'm a beginner in filemaker and relational database in general.

i'm trying to get my head around these two relationship set-up for category, which is better between the two and why?

(Tables) are:

product

customer

product_category

customer_category - retailer, distributor, manufacturer

 

(Relationships)

A. category is related to their particular tables

product is match to product_category

customer is match to customer_category

 

B. category is related to the tables by using a separate table

Here we add a table called CATEGORY,

the product_category and customer_category would be a join table

 

product is match to CATEGORY, and match to product_category

customer is match to CATEGORY, and match to customer_category

 

which is better of the two?

 

Thank You for the assistance!

Outcomes