P
Paputxi
I have two tables, say, TblA and TblB. There is a one-to-many relationship
between TblA and TblB. I have a form where I can navigate between each
record in TblA. (So, that works fine.) In the form, I have a combo box
where I want to display the records in TblB that are associated with the
current record from TblA. However, the combo box displays ALL the records in
TblB, not just those to the current record in TblA. I’m sure there is an
easy solution, but I can’t seem to figure it out.
Also, is there a way to have the first returned record from TblB displayed
in the combo box display? Right now, the combo box appears blank. However,
when I click the down arrow, I see the records.
Any advice would be greatly appreciated. Thanks in advance.
between TblA and TblB. I have a form where I can navigate between each
record in TblA. (So, that works fine.) In the form, I have a combo box
where I want to display the records in TblB that are associated with the
current record from TblA. However, the combo box displays ALL the records in
TblB, not just those to the current record in TblA. I’m sure there is an
easy solution, but I can’t seem to figure it out.
Also, is there a way to have the first returned record from TblB displayed
in the combo box display? Right now, the combo box appears blank. However,
when I click the down arrow, I see the records.
Any advice would be greatly appreciated. Thanks in advance.