Hi all,
Disclaimer: I have no database experience. However, I am a computer tech
and so therefore was given the following problem.
I have a customer who's been using a DOS dbase program, Disk-Count's
Business Contacts and Information Manager. This company apparently no
longer exists. My customer want to use something a little more updated than
a DOS-based program, so I thought we'd use Access.
I've imported the tables into Access just fine. The problem is cross
referencing. For example, there is the master contact table with customer
number, name, address, and comment fields and then a comment table with
customer number and additional comments that correspond to the master table.
How do I get the comment table linked or merged or whatever into the comment
field of the master table?
I hope I've explained this well enough, I've confused myself writing it.
Thanks for any thoughts on this matter!
Denise