Any reason to link tables with virtually unlimited fields? Record ID# on table?
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,