Display information in a form

[Guest]

Help Please!
I have an access dbase with two tables and I want to take information from
both into a third table and a form.
In my form I want to choose a Trainee (primary key) from table 1 and the
form will then display some other information from that record (eg address,
phone etc) and to take a placement (Primary key) from table 2 and the form
will dsplay other information from that record (contact details etc).
Can anyone tell me how to do this please?
Thank you.

 

[Jeff Boyce]

One way to approach this is to use a main form to display the Trainee
information (you can use a combo box in the header of the form to 'select'
which Trainee), and a subform based on a third table (Trainee x Placement).
In that subform, you can use another combo box to allow selection of which
Placement.

With the main form/subform construction, Access will ensure that the table
behind the subform receives the Trainee's primary key for each new record.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/