M
Matthew Pfluger
I recently transferred a large data-spreadsheet into Access. I created a
database that contains several tables and multiple relationships. I figured
out how to link primary keys from one table to another and use lookups in
forms to enter data quickly, but I'd like to be able to select an item from
the lookup list and have that value dictate other values in the record.
For example, if I select a familyID from the lookup combo box, I want the
family's head of household to automatically display in another column in that
same record.
Is that possible? Or is that bad practice?
Thanks,
Matthew Pfluger
database that contains several tables and multiple relationships. I figured
out how to link primary keys from one table to another and use lookups in
forms to enter data quickly, but I'd like to be able to select an item from
the lookup list and have that value dictate other values in the record.
For example, if I select a familyID from the lookup combo box, I want the
family's head of household to automatically display in another column in that
same record.
Is that possible? Or is that bad practice?
Thanks,
Matthew Pfluger