One Time Qry Needed

One Time Qry Needed.

I am attempting to further normalize a table that I have. Previously I had a check box that indicated that a document was received. As the years go by now, we have started collecting multiple documents and they are all indicated by a check box. I want to move the check boxes out of my main table and into a table called documents (Tbl-Documents).

I wanted to use an append qry to do this, but when doing the selection, the results are wrong. I tried doing a select qry for each of the documents and then putting them into the append qry with the same results.

To keep the question as clear as possible, I will just use some generic terms

Tbl-People
PK-PeopleID
Document1 (y/n)
Document2 (y/n)
Document3 (y/n)

Plus a number of other documents

* It is possible for people to have any combination of the documents checked as yes and not every record will have at least one of them checked as yes.

Want to take the above (y/n) from Tbl-People and put them into Tbl-Documents.

Tbl-Documents
FK-PeopleID
PK-DocumentID (Auto)
Document1 (y/n)
Document2 (y/n)
Document3 (y/n)

Plus a number of Documents more

Once the append qry is completed I will amend my other qrys to point to the right Tbls and delete these fields from Tbl-People.

If this was not originally set-up this way, I think I would have had a Tbl-Documents (1 to many) with Tbl-People and “named” the documents in a field called DocumentsName or something like that, but there is too many records to rename I think at this point.

As always, all help is appreciated, and please feel free to criticize my approach to this situation.

Navyguy