G
George
Dear friends, need your help again.
I have a table (tbl_Applications). Two of the fields of this table named
firefighter and lookout are YES/No field. In a related table (one to many -
tbl_AppliedFor) I have a combobox based on a third table tbl_Stations (it has
an ID, a meaning and a Type (numberbyte).
When I select the firefighter (true) then I need to appear in the combobox
only those records having the Type=1, when I select Lookout in the combobox
only those records having the Type=2, when selecting both Firefighter and
Lookout I need to see all the records in the combobox.
Any help will be highly appreciated.
Thanking you in advance,
GeorgeCY
I have a table (tbl_Applications). Two of the fields of this table named
firefighter and lookout are YES/No field. In a related table (one to many -
tbl_AppliedFor) I have a combobox based on a third table tbl_Stations (it has
an ID, a meaning and a Type (numberbyte).
When I select the firefighter (true) then I need to appear in the combobox
only those records having the Type=1, when I select Lookout in the combobox
only those records having the Type=2, when selecting both Firefighter and
Lookout I need to see all the records in the combobox.
Any help will be highly appreciated.
Thanking you in advance,
GeorgeCY