can i view two subdatasheets at a time?

[neha]

i'm new to Access so i'd really like some help

i have one table that has a one to many relationship with two other tables...can i view both those child tables in a subdatasheet view when i'm working on my parent table?

[boblarson]

No, you can't (you have to pick which one will open when you click the plus sign). But you can use two SUBFORMS to view at the same time as a main form.

Personally, I don't believe anyone should be working on tables/queries directly (with the only exception really being when the developer is developing).

[neha]

thank you!

yes, i'm in the process of developing the db and subdatasheets really help me see that the table relationships i've made are working properly.

i did make a form with subforms, but i'm not able to enter data into a table via the subform. for example, i have a ProductTbl and a ManufacturerTbl and then a DistributerTbl. The ManufacturerTbl and DistrbuterTbl are linked to the ProductTbl by a one-to-many relationship (one Manufacturer/distributer, many products).

I want to create a form based on the ProductTbl with the ManufacturerTbl and DistributerTbl as subforms and I want to be able to enter data into all three tables by the same form. I created one but I can't enter data or modify data in the tables via their subforms. Also, the subform looks like a datasheet, is there any way I can view it differently? It would be helpful if someone could tk some time to explain to me how subforms work.

Thanks!

[boblarson]

See if the tutorial here
http://www.functionx.com/access2007/Lesson31.htm
(go down the page a bit until you see Subforms/Subreports)

[neha]

Thank you very much! That definitely solves my problem and then some