Connect one table to multiple fields in the same table

[Guest]

Novice/Access 2003

How can I connect one table to two or more fields in the same table in a
one-to-many relationship?

Example tblWriters to fields: Writer1, Writer2, & Writer3.

I want to record who updated some text and several writers could have
contributed to the same text.

I've joined tblWriters to Writer1, tblWriters_1 to Writer2 , and
tblWriters_2 to Writer3. This updates the fields successfully, but when I
check the table and click the + sign to look at the attached records, there's
nothing there.

I've searched, but can't find any reference to this. Does it need to be done
by a query?

Thank you

Peter Stone

 

[Guest]

Hi

It is a good idea to create a query 1st with just tth information you want
on your subdatasheet

Then just open the table and click insert

Select subdatasheet and select the one you want from the list (select the
query you have just made)

Of course you "can" choose to have a whole table as the subdatasheet "but"
that may be bit a big big for what you want.

Give it a try. You can always delete it after if you dont like it.

 

[Guest]

Ken you may not come back to this after so long. But: I had several questions
running at this time and missed the notification. Just now, I found your
reply on Google groups. You answered my question perfectly and at length and
solved my problem.

Thanks very much

Peter

 

[Guest]

Peter:

Thanks for the feedback. Glad to have helped.

Ken Sheridan,
Stafford England