Form with 2 (two) subforms

[wcboyd]

Hello All,

I am struggling with how to do this ( I am sure I am having a bit of a brain lapse).
My form has two ids from two master tables (MstrTableA_Id & MstrTableB_Id). The two MstrTable Ids are tied together by a surrogate key to show that they are related.
So I should be able to scroll through the two master table relationships and have the appropriate child records be displayed (in a none updateable method) for each master.

For example:

             MasterTableJoinRelationshipID
MstrTableA_Id                           MstrTableB_Id
=======================================
ChildRecord1                             ChildRecord1
ChildRecord2                             ChildRecord2
etc...

[PreviousBtn]                          [NextBtn]

So are the child records contained in Listbox or subform?

Does this make sense?

Thanks,

 

[Simon_MT]

You should put them on a subform and perhaps on a tabulated parent form.

Simon

 

[boblarson]

As long as the ID's are linked, you should be able to scroll through the master and have both subforms change. The subforms can be displayed in single form, continuous form, or datasheet form view and datasheet view seems to be what you're looking for.

 

[wcboyd]

Thanks guys. That cured my brain lapse!!!!!