Firstly, I apologize if this question has been answered elsewhere, I wasn't sure about the right wording to find the answer. Here's my issue:
I got burned with the current database I am building because I used lookups at the table level. I have since fixed them and removed all the lookups. I have two tables: tblFamily and tblChild. In the child form I have the ChildLastName combobox which looks up the FamilyLastName values from the tblFamily table; and stores the value in the ChildLastName field (it is a short text field type). The problem is that it seems as though that value is stored alone and if, for instance, I update the family last name it does not update the ChildLastName value.
The combobox is set up as follows:
Column count: 1
Bound column: 1
Data: ChildLastName
Lookup: FamilyLastName from tblFamily
I'm sorry if this is a very beginner question, thank you for any help!
I got burned with the current database I am building because I used lookups at the table level. I have since fixed them and removed all the lookups. I have two tables: tblFamily and tblChild. In the child form I have the ChildLastName combobox which looks up the FamilyLastName values from the tblFamily table; and stores the value in the ChildLastName field (it is a short text field type). The problem is that it seems as though that value is stored alone and if, for instance, I update the family last name it does not update the ChildLastName value.
The combobox is set up as follows:
Column count: 1
Bound column: 1
Data: ChildLastName
Lookup: FamilyLastName from tblFamily
I'm sorry if this is a very beginner question, thank you for any help!