go to a related record

[Lynn atkinson]

Does anyone know how I go to the related record in another
table without manually opening the table and searching for
ID5. Is there a way of setting up a button to go directly
to the details relating to that employee in the contract
table?
Eg I have details for employee ID5 in the employee table
and I want to view the contract details of that employee
in the contracts table

Is there an easy solution without getting heavily into
visual basic?

 

[Simon]

If u are using a form to display the data, go to design
view of the form displaying 'employee table data'. create
a button. when the wizard opens, select 'Form operations'
from categories and 'Open Form' from actions. hit next.
select form showing details of contract table. hit next.
Choose 'open the form and find specific data to display'.
hit next. match up the two fields containing employee ID,
hit next and your done. wizards all the way!

 

[lynn]

Thanks very much for the useful info. I have used it
already!