Hello all -
I have a data bank that is organized primarily by a list of addresses. Each address has a patch of various types of files (word documents, pdf printouts, separate picture caches). Information among the patches will include one or more names for correspondence. There may be multiple addresses that share names.
My most preferable goal is to create an interface that, upon bringing up a name, will display any addresses that are associated with the name and/or correspondence established with the person. I have started an Excel file that has the addresses in each row the first column, and am planning to put each name associated into each following column.
Basically speaking, if someone calls, then I'd like the name to bring up each address and account of correspondence. Preferably, being able to access the information by address is helpful to.
I was going to post this in the Excel forum, but I think the ultimate interface is going to be a query in Access, so here I am.
Thanks so much.
Bookmarks