Ok, I'll expand on what happened:
The data in Field1 is the ID (Alphanumeric)
The data in Field2:Field22 is text
Field2 is the file_name of the "parent" while field3:field22 are the names
of files contained within the parent.
I have given the parent file a unique ID, but I also want to give the
"subfiles" unique IDs as well. In order to keep the relation between parent
and subfiles clear, I thought that the subdatasheet would make this possible.
So, I turned on the Subdatasheet so that the Master Field is Field2 and the
Child Field is Field3.
As I move the Field3:Field22 files into the subdata sheet, I received an
error message saying that I was not allowed to input duplicate information.
This occurred because some of the "subfiles" have the same title (e.g.,
"correspondence").
While my initial question was how do I get Access to accept duplicate
entries that I enter into the subdatasheets for different records, perhaps my
unwritten question is: Can this be done in a more efficient manner?
Lastly, I call the fields Field1, Field2, etc. as Field* is the default
title for fields in Access before you rename them. As the actual title
shouldn't have bearing on what I hope to achieve, I simply omitted them.
Thanks for asking the tough questions! I hope someone can see light at the
end of the tunnel for me!
