table link info

K

Kerry

On our database we have the following:

One table called DOCUMENTS.
One table called People.
One table called Clients.

The Document table/form enables the user to enter the filepath etc for WORD
DOCS associated with each Person. Is it possible to also link the document
table with Clients instead of creating a new table for clientdocuments? If
so, how would the current Document table link with the Clients? As at
present the Document table is linked with the people via PersonName.

Any help would be terrific, thankyou.
 
D

Douglas J. Steele

It all depends on your data.

If a document can only be associated with one client, you can put an
additional field in the document table to point to that client.

If, as I would expect is the case, a document can be associated with more
than one client, you'll need another table to link documents to clients.
 
K

Kerry

Thanks, I expected that this might be the case, because of the multiple
entries...
Thanks again for your help.
 
Top