Having Files linked to a record

[BlackTL]

I want to create a database so that it will have information about a customer and a list of files (may be all file types) that are associated with that record.

For example:

I have a customer John Doe Corporation and I have all information about this customer: Name, Phone, Address, etc. Now, I would like to attach a few files so that everytime I pull up this customer, I can see what files I have for them and can click and open any file that I want. Does this make sense?

The user should be able to:
Add a file
Delete a file
Double click on the file to open it

Will this be hard to do?

Thanks in advance,
RP

 

[WildHare]

Yes, you can do this. Your reference to a FILE is probably going to want to be a HYPERLINK data type. Simply build a table with your customer id and hyperlink field, and think of it as the MANY side of a one-to-many with your customer. When you click a hyperlinked value, it should open the target file in the appropriate application.



If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm