How do we create a subtable in access. When you open a table. First column come with + singn. When you click the + sign you get another sub table. How do we creat that table. What is the purpose of this table?

regards,
- Mahen

It is called relation between two tables, relation b/w tables are of 2 types, one-one & one to many

Hi,
Thank you for your response. Yes you are right. There are two types of relationship.
What it purpose of subsheet when you click the +sign in a table?. Please explain in detail.
See the neileg's db1 example in the forum. (under subtable).
Thanks,
- Mahen

the purpose of the plus sign, is to help the user see related records - so if you have an order, you will probably see the related order lines

now all of this behaviour can be programmed in, and in most cases you dont want users to open tables directly, and you should access your data via forms - in this case the plus sign is at best an irrelevance, and at worst an inconvenience, as maintaining the links actually slows access down a bit.

There is a fix to get rid of the plus signs, so if your performance starts to deteriorate you can look at that - otherwise you're best ot ignore the plus sign

you probably

gemma-the-husky,
Thats make sense. Do you have any examples to send me?
Thanks
- Mahen

examples of what?