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?
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).
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