Table lookup info

[jwr]

Once a table is created and information input, I open in database view. I
see a + next to each line. When I click on the + sign, the information is
not what I want to see. Can this be changed and if so how?

Thank you,
JR

 

[Scott McDaniel]

Those are "subdatasheets" ... you can relate two tables together and the
child records would show when you click the + next to parent records. To
view your table relationships, click Tools - Relationships

FWIW, this can put a major hit on performance (and users should NOT be
directly editing the tables) ... most people turn OFF subdatasheets. You can
implement similar functionality with a datasheet subform embedded in a
datasheet main form ... if your tables are properly related, Access will
show these relationships just as you see them in the table Datasheet view.

 

[Allen Browne]

Open the table in design view.
Open the Properties box (View menu).
Set the SubdatasheetName property.

For a better result, create a query that combines the 2 tables you want to
see.