I would like to display the first name and last name of a person in the form header of forms bound to different tables when selected in a listbox (filter is PersonID) from a main form. Example
TableA
PersonID 1
FName John
LName Doe
TableB
PersonID 1
FieldA
FieldB
TableC
PersonID 1
FieldD
FieldE
Each table is bound to a form from which it gets updated. I started of with 1 table containing all the fields, but I really was getting too long. I tried to split the table using the table analyzer, but that didn't get me there. If I use a query than it won't let me update.
Any suggestions
TableA
PersonID 1
FName John
LName Doe
TableB
PersonID 1
FieldA
FieldB
TableC
PersonID 1
FieldD
FieldE
Each table is bound to a form from which it gets updated. I started of with 1 table containing all the fields, but I really was getting too long. I tried to split the table using the table analyzer, but that didn't get me there. If I use a query than it won't let me update.
Any suggestions