Autofill Information On Click

M

mkern

Good afternoon, I have developed a database and have come to a halt as I am
having trouble getting a certain functionality that I want. Here is the
skinny- I have a form that contains information for customer name and phone
and blah blah blah then I have a tab that has CONTACT name and Phone and blah
blah blah I would like a button that when clicked copies the information from
the customer tab over to the contact tab alot of times these are the same and
it seems pointless to have to reenter the same info. all the feilds come from
the same table. Can you explain to me how to go about doing this it is
driving me nuts. I thank everyone in advance. I did look at prior post but
did not find this specific question.
 
P

pietlinden

mkern said:
Good afternoon, I have developed a database and have come to a halt as I am
having trouble getting a certain functionality that I want. Here is the
skinny- I have a form that contains information for customer name and phone
and blah blah blah then I have a tab that has CONTACT name and Phone and blah
blah blah I would like a button that when clicked copies the information from
the customer tab over to the contact tab alot of times these are the same and
it seems pointless to have to reenter the same info. all the feilds come from
the same table. Can you explain to me how to go about doing this it is
driving me nuts. I thank everyone in advance. I did look at prior post but
did not find this specific question.

Why not just move all the customer info into the contact table and add
a "customer" flag. Then you can add as many contacts as you want.
 
M

mkern

Good afternoon, I have developed a database and have come to a halt as I am
having trouble getting a certain functionality that I want. Here is the
[quoted text clipped - 6 lines]
driving me nuts. I thank everyone in advance. I did look at prior post but
did not find this specific question.

Why not just move all the customer info into the contact table and add
a "customer" flag. Then you can add as many contacts as you want.

All the information is in the same table. I only need one contact and the
point is not to add additional contacts the point is sometimes the info is
the same and I want to not have to enter the info twice. A customer flag I am
guessing what you mean by that is just a heading that dictates which contact
is the owner. Maybe I need to clarify that by customer I mean Owner and and
by contact I mean a single contact besides the owner that is all I need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top