Relationship Drill Down

[Paul7905]

This may be a particularly stupid question however I need to ask it.

I have two tables in which there is a one to many relationship. I established the relationship ok.

When i view the table on the one side of the relationship in datasheet mode by clicking on the table name, I see, on the left side of the table (first column in the display) a minus sign (-). When i click on this, access automatically displays the data from the table with the "many" relationship.

Essentially i think this is pretty cool however the feature only seems useful to me from the standpoint of being able to use it to verify data while i am designing my application.

What I am interested in finding out is whether there is a way to easily utilize this "drill down" feature on a form for the user to use.

For example, i would like to be able to display the table with the "one" relationship and allow the user to click on the minus sign so as to display the "many" side table rows.

Is there any way to take advantage of the one to many relationship for client or user benefit on a form?

thanks
Paul

 

[Databaseguy]

What you just described is a sub form within a form. This is the exact purpose you would use one of these for. Look at the Northwind sample DB, and you'll see how a one to many relationship can be represented on a form. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy