Hi all,
I have a a form 'clientForm' based on a database called 'clientDB'. In this 'clientForm', I have a subform, that lists all the 'brands' related to the 'client' record being displayed (linked by a one to many relationship).
brandDB.Client ID (foreign key) many - clientDB.Client ID (primary key) one
I created a combo box that lists the 'brands', which controls which record is being displayed, however the combo box shows all 'brands' not just the 'brands' related to the 'client' record.
IE: the subform displays 2 records, but the combo box within the form, displays the whole list of records.
How can I get the combo box, to only display the records that are determined by the client record? IE: only records that equal the client ID (like the rest of the subform)
Thank you!
I have a a form 'clientForm' based on a database called 'clientDB'. In this 'clientForm', I have a subform, that lists all the 'brands' related to the 'client' record being displayed (linked by a one to many relationship).
brandDB.Client ID (foreign key) many - clientDB.Client ID (primary key) one
I created a combo box that lists the 'brands', which controls which record is being displayed, however the combo box shows all 'brands' not just the 'brands' related to the 'client' record.
IE: the subform displays 2 records, but the combo box within the form, displays the whole list of records.
How can I get the combo box, to only display the records that are determined by the client record? IE: only records that equal the client ID (like the rest of the subform)
Thank you!