Pop up form

[Guest]

Hello,

I have a table of club members with PK MemberId (autonumber) and a table of
members' parents with FK MemberId. I have a form based on the members table
for entering member information and I would like to include a button that
opens a form for entering parent information for the current member. How can
I do this so that one or two parent records will be tied to the current
member? Also, how can I make the parent form say something like
"Parent/contact info for: <current member name>" at the top?

Thanx,

Rip

 

[Allen Browne]

Presumably this is some kind of youth club where the parents cannot also be
members? It still seems likely that one parent could have multiple children,
so a MemberID f.k. in the parent's table won't cope with that.

For the simplest arrangement, you might just add 2 fields to the members
table:
MotherID f.k. to tblParent.ParentID
FatherID f.k. to tblParent.ParentID
This lets to enter either a father or mother or both. It does not cope with
step-parents etc.

With that arrangment, you could add a subform to the form where parents are
entered. The subform shows the children.

If it is possible that the parents could also be members, consider including
the parents in the members table. You can join the table to itself.

If you need to cope with more complex relations between people (such as
step-parents), see this article:
People in households and companies - Modelling human relationships
at:
http://members.iinet.net.au/~allenbrowne/AppHuman.html
Includes a sample database for A2000 and later.

 

[Guest]

Thanx, Allen. The main thrust here is the members. I just need a couple of
contact names & phone numbers to go with them; not even parents necessarily.

I would like a form to enter the member info, which is extensive, then a
form to enter the contact info that goes with the current member. I would
like it in a popup form, but if that's too complicated, a subform is OK. How
might I arrange the fields/relationships in this arrangement?

Thanx,

Ripper

 

[Allen Browne]

Subform would be the simplest to set up.

Your contact table has a MemberID foreign key, so the subform will
automatically show the correct contact people from the related table.