AnsweredAssumed Answered

Linking one table to several others

Question asked by dunkake on Mar 20, 2013
Latest reply on Mar 21, 2013 by LabsRock

I'm building some sort of document mgmt section.

The idea is to have just one document table (with a container field for the actual document).

 

I’m stuck with the solution to link one “document record” e.g. to an invoice record and another to a contact record (given that “invoices” and “contacts” are separate tables).

 

I can’t just have a "generic foreign ID" field in the documents table and put in one case an “invoice ID” in it and in another case a “contact ID”, can I?

 

Thanks in advance for your hints!

Outcomes