Skip to Content
Former Member
Sep 22, 2008 at 06:32 PM

Select Expert - Record


I'm trying to limit the values presented in the Select Expert - Record tab based upon it's relationship to a selected value from another field.

We have several hospitals. Each hospital has several floors or unit/wards usually identified as 6 East, 2 West, 4 North, etc. Not all of the hospitals have the same named unit/wards.

I select use select expert - table_name.Facility_Name = "Hospital A" when I select table_name.Unit_Name I only want those units/wards from the "Hospital_A" to be displayed in the list and not all of the units/wards that are listed in the table. This way I do not have to wade through all of the unit/wards that a facility does not have. The report is for unit/ward.