Forms Filter using drop down list?

[Larry1216]

Have a main form for Health Plan Member Demographics based on a table.
A subform with Physician Demographics that the members have seen is based on a second table. The member usually has seen more than one physician.
The two tables are connected in the subform by a common identifier in each.
Would like to have users see the list of Unique Physicians, Physician Zip Code, etc and only show the Members associated with those doctors etc.
Is this feasible?

 

[PHV]

Build a mainform based on Physicians and a continuous linked subform based on Members ?

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