Hi!
I need to create 6 subdatasheets (subordinated) in a table. Because the subdatasheets have a lot of duplicate entries, I can't use a primary key in them and hence after creating one subdatasheet can't have another subdatasheet under it. I wonder if there is any way to get around this.
In attachment as an example I have created one main table and two subdatasheets. The subdatasheets can have multiple duplicate entries. In the "Main Table" if you go to column ID and row 74, you can see that it makes references to the subdatasheet. But here I couldn't have one more subdatasheet under this subdatasheet because Access didn't allow me to set a primary key in it.
Any help would be very much appreciated!
Nick