Form w/multiple subforms

Jmaddog

Registered User.
Local time
Today, 08:09
Joined
Sep 23, 2008
Messages
28
I would like to create a form that has main form and two sub forms in a tabular format - relating to the main form. Is this possible? Everything I find states that the second subform needs to be related to the first subform. Is this correct? If it is, what is the best way to accomplish this?
Thanks
 
Not true, a main form can have two subforms related to itself. What are you trying to do, what tables are involved, etc.?
 
Thanks for the reply. Here is what I am trying to do. I have a main table that has all adjusters or employees along with (adjuster code "unique" and ee# "unique"; address; etc.). I have an HR table that includes (ee#; hire date; hrly rate; gross salary; OT hrs; OT $'s - this data is compiled monthly). I have another table that has monthly expenses for each adjuster and this is also compiled monthly - this table also is related to the adjuster table. I would like both of these tables to be subforms relating to the mainform - which is the adjuster table. When I do this with only one subform (expenses) it works correctly, but when I add another subform (hr data) it adds all adjusters info instead of only the adjuster from the main form. Any idea on how to make this work?
 

Users who are viewing this thread

Back
Top Bottom