I have a form with several subforms. The main part of the form is company
data. One of the subforms contains volunteers names & addresses. Many of
the volunteers work for several companies.
What I would like to do is when I start typing in the volunteers' name,
and
select one, the address would autopopulate into the rest of the form.
Right
now, I have the volunteer table include the "company number", so I can
sort
by that number also. I don't think it NEEDS to be there, but I'm afraid
if I
wipe it out...I'll have NO volunteers for any companies.
So...2 questions:
If I change primary keys, which means I would have to get rid of the
duplicates, how can I keep the data associated?
How do I autopopulate the rest of the data once I have the name chosen?
Thanks in advance...
|
