Two records on 1 form

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. ???

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.

--
Duane Hookom
MS Access MVP


"Widemonk" wrote in message
...
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. ???

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" wrote:

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.

--
Duane Hookom
MS Access MVP


"Widemonk" wrote in message
...
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. ???

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

--
Duane Hookom
MS Access MVP
--

"Widemonk" wrote in message
...
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" wrote:

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.

--
Duane Hookom
MS Access MVP


"Widemonk" wrote in message
...
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. ???

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

Just SOME of the fields a
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" wrote:

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

--
Duane Hookom
MS Access MVP
--

"Widemonk" wrote in message
...
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" wrote:

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.

--
Duane Hookom
MS Access MVP


"Widemonk" wrote in message
...
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. ???

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

--
Duane Hookom
MS Access MVP
--

"Widemonk" wrote in message
...
OK. I'm probably not explaining it very well.

Just SOME of the fields a
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" wrote:

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

--
Duane Hookom
MS Access MVP
--

"Widemonk" wrote in message
...
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" wrote:

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.

--
Duane Hookom
MS Access MVP


"Widemonk" wrote in message
...
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. ???