AnsweredAssumed Answered

Any reason to link tables with virtually unlimited fields?  Record ID# on table?

Question asked by CorreenFrappaolo on May 17, 2012
Latest reply on May 17, 2012 by philmodjunk

Title

Any reason to link tables with virtually unlimited fields?  Record ID# on table?

Post

Good afternoon!

I have only worked with Access. 

I am in the process of creating databases for my employer using FileMaker Pro 12.

Here is what I am trying to do (please advise):
     ProblemTable:  Customers will select from 1-100 check-boxes (Boolean fields, I know).
     AdviceTable:  These check-boxes will determine recommendations (etc.) for fixing their problem (about 10 fields).
     ProductTable:  These check-boxes will also determine 1-500 products (check-boxes "checked" by the owner of the company) suggesting products the customer should buy, which will take them to the product on our website.

Is there any reason why I should have three tables?  I know in Access I would have had three linked tables, but only because of the max number of fields allowed in Access.

If I do need three tables, please tell me:
     How do I link the record number between the tables?  It's not a field in Relationships!
     How do I insert the Problem/Product tables into the Advice table's form?

With sincere gratitude,

Correen
    

Outcomes