Related Table View

P

Phil Jones

Can anyone tell me How I change the view of related tables in table view?

My current setting is to one table but I want to show another related table.

Thanks
 
A

Armen Stein

Can anyone tell me How I change the view of related tables in table view?

My current setting is to one table but I want to show another related table.

Thanks
Click to expand...

Hi,

While viewing the table in datasheet view, select View..Subdatasheet
from the menu. Choose the related table that you want to see. You can
only see one related table at a time. If you want to see more related
data, you can build a query that joins multiple tables together.

Hope this helps,

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com
 
J

John Vinson

Can anyone tell me How I change the view of related tables in table view?

My current setting is to one table but I want to show another related table.

Thanks
Click to expand...

I'd strongly suggest NOT using table datasheets for routine data
viewing (with or without subdatasheets). If you have one table related
to two other tables, you're almost sure to be better off using a Form
for the "one" side table with one or more Subforms for the "many".
 
Top