putting data in subform field from main form textbox object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables

Parent is "Members" and child is "Attenance
The main form contains one record for "Members" and the "CoreGroup" field is displayed (and updateable) in the "CoreGroup" listbox object on the "Members" form.

The "Attendance" subform is a list of all attendance records for each Member.
When I insert a new attendance record, I want to update that record's "CoreGroup" field with the current "Members.CoreGroup" field (or object)

Thanks in advance
Kell
 
If the CoreGroup value of an Attendance record, is always equal to the
CoreGroup value of the relevant Members record, then, you >should not have<
a CoreGroup field in the Attendance record. That is not the right design.

Instead, whenever you need the CoreGroup value for an Attendance record, you
should get it from the relevant Member record. This avoids unnecessary
duplication of values, with the attendant risk of having accidental
differences between the CoreGroup value in an Attendance record, and the
correct< CoreGroup value in the relevant Members record.
Click to expand...

HTH,
TC


KC said:
I have two tables:

Parent is "Members" and child is "Attenance"
The main form contains one record for "Members" and the "CoreGroup" field
Click to expand...
is displayed (and updateable) in the "CoreGroup" listbox object on the
"Members" form.
The "Attendance" subform is a list of all attendance records for each Member.
When I insert a new attendance record, I want to update that record's
Click to expand...
"CoreGroup" field with the current "Members.CoreGroup" field (or object).
 
The reason I am putting them in both places is that the Member's CoreGroup may need to change - and I want to be able to go back in the Attendance records for that individual to see what care Group they belonged to on such-and-such a date. Regardless - I would still like to know how to do this type of "update" whether or not the design is "judged" to be a bad one

Thanks
 
Back
Top