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!!