Two records on 1 form

[Widemonk]

Can I display the details of 2 records on a form view?? Let me explain why.

I have a membership database that as well as the usual 3 address lines &
d.o.b. etc etc, it also records a next of kin (incl. their full address
details etc).

Normally I would create many fields for each record except some people who
are down as N.o.K are also members. This leads me to list each person by
themselves with an additional yes/no field to denote if they are a member or
JUST a N.o.K.

So when a member is displayed on the form, can I also display details from
another record who is down as their N.o.K. ???

 

[Duane Hookom]

You should be able to do this with a subform. You haven't provided any table
structure or information on how the pairs of nok are related.

 

[Widemonk]

Sorry...

Only 1 table because I'm trying to make it self-join.
Primary key is MemberName (I expect this list will have no more than 100
names which is why i havent used AutoNumber as the primary)
In relationships, i've added the table a total of 3 times and joined:-
table_1.membername to table.NOK1
table_2.membername to table.NOK2

 

[Duane Hookom]

Your subform can be based on the same table. I'm still not sure which fields
are linked to which fields.

 

[Widemonk]

OK. I'm probably not explaining it very well.

Just SOME of the fields are:
Name, Street, Town, County, Phone, DOB, Membership Type, NoK1 Name, NoK1
Street, NoK1 Town, NoK1 County, NoK1 Phone, ... and all the same for NoK2 etc

Now, I have an adult member who may also have two kids as child members too.
That adult now has their address unlinked in 3 places... their own address
and as the NOK for each of their two kids.

Instead, if I have each person as a separate record and somehow link the NOK
names to the Name field of other records, I can remove a quarter of my
fields, but I'd still like it display those two or three records on the same
form

If i have a child as a member but their parent isnt, although the parent
would be included in the list (solely as NOK for their child), their
membership type (say, 'parent') would remove them from queries & reports etc.

Hope the mud is clearing up a bit !!

 

[Duane Hookom]

I wouldn't do anything until the structure was properly normalized. Consider
reviewing http://www.alphabetcitydataworks.com/fundamentals.htm