How to relate the master detailed form

[tekaccess]

HI

I want to select supplier id from combo and an invoice number against that supplier id. and I want to add all the product related to that invoice number on a subform.
HOW CAN I LINK THE SUPPLIER COMBO WITH INVOICE COMBO AND INVOICE WITH SUBFORM.
I have already create a master child realtionship between invoice and subform.
Will any body explain with an example.\
Thank you

 

[PHV]

Have a look at the combo section in the FAQ area.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886