Conceptual Question Here.
FM Pro 11
I'm constructing a new database and I'm not sure the best way to go about the following.
I have a table of CASES, and a table of INQUIRIES. Each table has a unique-auto entered serial number for ID, as well as a unique 'name' that will be supplied by the user (among other data fields).
I need a way to relate INQUIRIES and CASES.
I don't have much confusion with CASES, entries will be created and populated with no problem, they are the central focus of the database. I'm having trouble figuring out a way to create and manage INQUIRIES.
Will generally be created without any relation to any CASES, at least initially.
An INQUIRY should be able to later become related to one or more CASES.
Each CASE should be able to be related to one or more INQUIRIES.
My current Ideas:
Inquiries will be created on thier own layout.
'create' realtionships through user modifications in the CASES table, so that a field in CASES matches the ID of INQUIRIES.
But this only gets me halfway.....
Is there a solution to be had in creating a third table that serves as a sort of record of relationships?
What is they best way to set up matching fields between CASES and INQUIRIES?
Let me know if I can provide any more information, and thanks in advance.