subtable (1 Viewer)

mahen

Registered User.
Local time
Today, 03:08
Joined
Jan 13, 2008
Messages
56
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
 

gulsarwar

Registered User.
Local time
Today, 07:08
Joined
Dec 13, 2007
Messages
10
It is called relation between two tables, relation b/w tables are of 2 types, one-one & one to many
 

mahen

Registered User.
Local time
Today, 03:08
Joined
Jan 13, 2008
Messages
56
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
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 03:08
Joined
Sep 12, 2006
Messages
14,004
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
 

mahen

Registered User.
Local time
Today, 03:08
Joined
Jan 13, 2008
Messages
56
gemma-the-husky,
Thats make sense. Do you have any examples to send me?
Thanks
- Mahen
 

Users who are viewing this thread

Top Bottom