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!