Carry over buttons

  • Thread starter Thread starter Lauren
  • Start date Start date
L

Lauren

Hi all,

I am working in Access 2002 and I have created a database
that we use for tracking business contacts. My question
is: if I have a new contact for a company that already
exists in my database (Ex. Mr. Ed is from XYZ company and
I want to add Mr. Jones with XYZ company info) is there a
way to add a new record for the name only and duplicate
the company's info? It is a pain to enter in all of the
company information every time I have a new person for
that company. I heard of something called a "Carry Over
Button". Is this what I should create and can it be
created relatively easliy? If so, how would I create
something like this? OR is there an easier way? Any
informative feedback would be greatly appreciated.

Thanks in advance!
Lauren
 
A better solution would be to have two tables; one for the
Company information and one for the Contact information.
The Company table would have a unique key (called for
example companyId) and the Contact table would include this
key thus showing which Contacts are related to which Customers.

You would also have two forms; one for each Table. The
Contact form would have either a list box or combo box
control for the Company so that the user would be able to
see something that would identify the Company e.g Compnay
Name and it would translate that into the companyId.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top