table link info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thanks, I expected that this might be the case, because of the multiple
entries...
Thanks again for your help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query by DOB 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
Change one table link by vba 1
Child Table With Two Parent Tables 4
Search in Multiple Databases/ 3 or more tables 2
Assign multiple people to one record - easily 3
best way to make linked database - Stand alone 3
Linked Tables and SQL Server permissions 3

Back
Top