Split screen w/ two tables

[Guest]

I would like to know how to split the screen to show the master table (ie
vehicle info) and a table that contains service info for that vehicle?

Thanks,
Les

 

[Douglas J. Steele]

Create a form that shows the information you want from the master table.
Create another form that shows the service information you want to see. Use
the second form as a subform on the first form, making sure you set the Link
Child and Link Master fields correctly between the form and subform.

Realistically, you should never work directly with the tables.