LInk subform

[DeanReedy]

I have a main form that is Order, using the order table. I have a subform which uses OrderItems using the Items table. Now how do I link it so that only a Order's OrderItems appear in the subform.

Both table have the key of Order_id.

How do I filter on only the main form's current Order?

thanks,

Dean

 

[yummy7]

Hi Dean
its very simple. if you have forein key of OrderID in OrderItem table. From your toolbar drag subreport tool into mainform ,it will make subform automatically.
If subform is not working then manually changet he child and master feilds of subform.

 

[DeanReedy]

Where are the child and Master field in the subform? That is what I can not find.

 

[yummy7]

Select subform which is in mainform.Right click --go in properties---Data tab----See Link Child fields and Link master fields.Write
Child fields foriegn key
Master Fields Primary key

 

[DeanReedy]

thanks, worked great