| | |
|
|
|
Related Table View |
|---|
| message from Phil Jones on 10 May 2004 |
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
|
| Armen Stein replied to Phil Jones on 10 May 2004 |
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,
|
| John Vinson replied to Phil Jones on 10 May 2004 |
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".
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: Related Table View (Microsoft Access Forms)
