Subforms

[Guest]

I have a main for that hold information to a vendor. I would like to put a
subform on there so you can see the account information, etc that is a
seperate table. I have added the subform , however, I do not know how to see
only the information pertaining to this certain vendor. I put a relationship
between the two vendor names, but that doesn't work the way I would like. I
am pretty new to the whole access application. Any help is greatly
appreciated!!
Thanks in advance!!

 

[Guest]

Use a query as record source for the subform that has the vendor table left
joined to the account table. Then open the main form in design view and
click on the subform. Richt click and select properties. Use the vendor for
the Master/Child links.