What is the difference between these table relationship
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?
customer_category - retailer, distributor, manufacturer
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!