L
leon
I have a table in which records are uniquely defined by four columns,
being
name, counterparty, account and date. I now want to make a form (bound
to the table) in which a user can filter down to the record he wants
to see by selecting values from comboboxes (and than make adjustments
to the record) . This means there are four comboboxes required. I do
know how to do this if a record is uniquely defined by just one
column (and therefore just one combobox is needed). But with four
comboboxes it's a whole different ball game since the possible choices
in one combobox should be dependent on the choice that has been made
in the other comboboxes. Further more since the number of records in
the table is quite big i only want to see each value once in the drop
down list of each comboboxes: for example there are only two possible
names so i only want to see two names in the "name" combobox and not
100 times the same name if there are 100 records with that same name.
Can anyone please help me with this preferably with an example
database? I have already spent hours and hours to figure this out but
I really cannot get it to work
being
name, counterparty, account and date. I now want to make a form (bound
to the table) in which a user can filter down to the record he wants
to see by selecting values from comboboxes (and than make adjustments
to the record) . This means there are four comboboxes required. I do
know how to do this if a record is uniquely defined by just one
column (and therefore just one combobox is needed). But with four
comboboxes it's a whole different ball game since the possible choices
in one combobox should be dependent on the choice that has been made
in the other comboboxes. Further more since the number of records in
the table is quite big i only want to see each value once in the drop
down list of each comboboxes: for example there are only two possible
names so i only want to see two names in the "name" combobox and not
100 times the same name if there are 100 records with that same name.
Can anyone please help me with this preferably with an example
database? I have already spent hours and hours to figure this out but
I really cannot get it to work