Need help- somewhat new to access

[NickW]

I have two tables. One is contact information. The other is job information
( for DJ business such as event date, time, etc.) i have one form for
contact information. I use contact ID #'s. in the new "job" table I have
both contact id #'s and event id #'s. I have set up a one to many
relationship on the contact id fields. I'd like to make a new form to set up
gigs. So, i'd like to put in their contact ID # and have the form
automatically complete other information such as first and last name from the
contact information table. Is there a way to do this? I'm not finding it.

 

[boblarson]

NickW:

You don't store the redundant information in the tables. See here for more
on NORMALIZATION: http://support.microsoft.com/kb/283878

You just store the ID of the person in the other table and then when you
need to report on it or select it you use a query to pull that all together.
See here for more on queries:
http://www.functionx.com/access2003/Lesson17.htm

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[NickW]

Okay. i now have the query. Now, how do I use this in a form format?
Again, I want to be able to have one FORM (not a table with redundent
information), where I put in the contact id and it automatically displays
their first and last name from one table ( or from the query). I then alter
information on another table (or in the query since it's the same). How do I
associate a form with a query instead of a table?