-
creating subdatasheets
Ok heres my table layout first so you can picture my DB. I have one master table with clients name, phone, etc.. i have another table with the clients equipment (type, model, etc..). I have another table with the clients tickets (for tech assistance). I have one more table with the clients credentials (such as user,pass etc that we need to access their web servers). I created a one->many relationship from clients to each of the other 3 tables. The related fields are called ID (clients ID is a PK - the others are not).
heres the prob:
In access 2007, when i open the clients table i want the other 3 linked tables to show up under it with the + so i can expand the other three tables and see the related info. Access makes me create a subdatasheet and link one of the tables (via their associated field) to view them. This only works with one table. I cannot create 3 subdatasheets under one table. Is this possible or is there another way to do this (other than creating a form or something?
thanks
any advice is greatly appreciated!!
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules