J
Joseph Greenberg
This might be a most basic question but I'm stumped.
I want to be able to have a dropdown that lists the names of possible
"attachments" on a childform. The application is a membership database. The
parent form is the overall family information, and the specific childform
(on a tabbed control) is to display and enter Death commemorations (we track
when members lose family members to death).
My tables structure is as follows (irrelevant fields left out for brevity):
tblHeader - has fields called FamNo, SeqNo, FamilyName, Member1, Member2,
Sex.
tblDetails - FamNo, SeqNo, FirstName
tblCommemorate - FamNo, SeqNo, Label, Date
We have a convention that if there is a male head of household, that is
Member1 (so shoot us for being sexist, I didn't set it up
). But if there
is a single female head of household, she is Member1.
FamNo is defined as a 1:1 connector for all relevant tables in the database.
The first member is assigned SeqNo=1, the spouse is assigned SeqNo=2,
children are assigned SeqNo=3 and higher, incrementing one per kid.
tblHeader has Member1 first name and Member2 first name.
tblDetails has records for every person - member1, member2, and all
children. But FirstName is only populated for children records.
The parent form's record source is tblHeader, as a dynaset.
The Commemoration chilldform's record source is a query that includes (from
tblCommemoration) FamNo, Date, Label, SeqNo, and a calculated field
(Observer) that brings in either Member1 or Member2 from tblHeader.
I want to put a dropdown on the childform whose possible entries are any of
the members (SeqNo=1 through SeqNo=N, for the current FamNo being
displayed), such that if there is a record with a valid SeqNo in
tblCommemoration, it displays the correct Observer (the individual family
member that observes the event), or if I'm creating a new commemoration
event, I select a name from the dropdown and it stores the appropriate
SeqNo. Right now, if I put a dropdown box and tie it to Observer, it only
shows me the Observer value, not any other possible Observer (my intent
woudl be that if multiple people in the same household observe the same
event, we'd have multiple entries).
Any help woudl be appreciated, and apologies for the long post.
Joseph
I want to be able to have a dropdown that lists the names of possible
"attachments" on a childform. The application is a membership database. The
parent form is the overall family information, and the specific childform
(on a tabbed control) is to display and enter Death commemorations (we track
when members lose family members to death).
My tables structure is as follows (irrelevant fields left out for brevity):
tblHeader - has fields called FamNo, SeqNo, FamilyName, Member1, Member2,
Sex.
tblDetails - FamNo, SeqNo, FirstName
tblCommemorate - FamNo, SeqNo, Label, Date
We have a convention that if there is a male head of household, that is
Member1 (so shoot us for being sexist, I didn't set it up
). But if thereis a single female head of household, she is Member1.
FamNo is defined as a 1:1 connector for all relevant tables in the database.
The first member is assigned SeqNo=1, the spouse is assigned SeqNo=2,
children are assigned SeqNo=3 and higher, incrementing one per kid.
tblHeader has Member1 first name and Member2 first name.
tblDetails has records for every person - member1, member2, and all
children. But FirstName is only populated for children records.
The parent form's record source is tblHeader, as a dynaset.
The Commemoration chilldform's record source is a query that includes (from
tblCommemoration) FamNo, Date, Label, SeqNo, and a calculated field
(Observer) that brings in either Member1 or Member2 from tblHeader.
I want to put a dropdown on the childform whose possible entries are any of
the members (SeqNo=1 through SeqNo=N, for the current FamNo being
displayed), such that if there is a record with a valid SeqNo in
tblCommemoration, it displays the correct Observer (the individual family
member that observes the event), or if I'm creating a new commemoration
event, I select a name from the dropdown and it stores the appropriate
SeqNo. Right now, if I put a dropdown box and tie it to Observer, it only
shows me the Observer value, not any other possible Observer (my intent
woudl be that if multiple people in the same household observe the same
event, we'd have multiple entries).
Any help woudl be appreciated, and apologies for the long post.
Joseph