Relationships and those Plus Symbols

[Sothpaw]

i've done many demos and tutorials... and when i see tables that are related to one another there are plus marks in the first column that expand to show the related data....
every time i try to create a relationship i don't get that kind of expansion?
what am i missing?

 

[stopher]

What version of Access are you using?

I assume you have your primary keys set up etc?

I might be easier to post your database to see what you've got rather than try and give you another tutorial.

I assume the + you see is the one that appears in the table view. This will only appear in the foreign table view. So if I have a customers table and an orders table (a customer has many orders), then you will only see the + in the customers table view.

While the + is a good check that your database is functioning ok, you should never allow users to see the table view. Instead you should use forms for users to enter data. There are many ways to show related data in a form.

Chris

 

[khawar]

You can creat it your self
open the table in design view
go to table properties
set property sub data sheet there
you have to set the master and child fields there

 

[gemma-the-husky]

but the plus marks arent realy that useful, and are best ignored, to be honest