linking documents to a record

B

Blakey300

Not quite sure how to word this but this is what i want to acheive

I have a DB with a customers table, I want to be able to save documents
created for a customer to the customers documents table. I have used a
foxpro DB in the past which allows this by the following method:

create file in word, which had a save to DB macro in the file menu, and this
macro automaticlly detected the current customer details that was open, then
all i had to do was enter a file name. This macro then created a folder for
the document which was somehow linked to the customers table. I could then
on the customers form click a docs tab which would list all saved docs for
the selected customer.

I hope this makes sense!!!
 
Top