form/subform

[tubar]

on my form u find a record by inputing 1 of 3 product numbers.
if a user inputs a product number for BRAND A
how can a record on my subform automatical display BRAND A company name

 

[mhartman]

Hello:
What you need first is a lookup table of all your product manufacturers and the products they manufacture. Then when a product number is keyed in your database, it can refer to that lookup table for the rest of the information.
'
Regards
Mark