Subdatasheet Indicator Missing, Properties Don't Save

[ebs57]

I'm currently not talking to my preinstalled version of Access 2003 mostly due to an argument I keep having with it regarding subdatasheets. Also because it has been drinking a lot lately.

I created an indeterminate relationship between two tables; no keys were used, just a Type 1 join between the common fields. When I then open my master table I don't see the plus signs. I know this may not be the best form but I am a beginner. I've said it, let's move on.

Okay...now I open the master datasheet in design view, open Properties and I see [Auto] in the "Subdatasheet Name" field. After the obligatory eye roll I select the foreign table (which I had just joined in the Relationships window, thank you very much) and the Child and Master Fields automatically fill themselves in. Looks good, so I close the Properties box and close the table. A "Do you want to save changes" pop-up appears and I click on "Golly!"

I re-open the master table and still no plus signs; I re-open the Properties box of the master table in design view and "Subdatasheet" is set back to [Auto].

What the?

[ADezii]

I'm currently not talking to my preinstalled version of Access 2003 mostly due to an argument I keep having with it regarding subdatasheets. Also because it has been drinking a lot lately.

I created an indeterminate relationship between two tables; no keys were used, just a Type 1 join between the common fields. When I then open my master table I don't see the plus signs. I know this may not be the best form but I am a beginner. I've said it, let's move on.

Okay...now I open the master datasheet in design view, open Properties and I see [Auto] in the "Subdatasheet Name" field. After the obligatory eye roll I select the foreign table (which I had just joined in the Relationships window, thank you very much) and the Child and Master Fields automatically fill themselves in. Looks good, so I close the Properties box and close the table. A "Do you want to save changes" pop-up appears and I click on "Golly!"

I re-open the master table and still no plus signs; I re-open the Properties box of the master table in design view and "Subdatasheet" is set back to [Auto].

What the?

Is it possible that you have the Indeterminate Relationship reversed for the Datasheet/Sub-Datasheet structure?

[ebs57]

Is that important in an indeterminante Type 1 relationship and are you referring to the "Child/Master" fields in the Properties box?

Regarding the "Child/Master" jazz, when I enter the name of the table in the "Subdatasheet Name" field, the child and master fields fill in automatically, only each table has the same name for the fields I am linking so I don't know which is child and which is master. In the Relationships diagram, the tables I've selected under "Table/Query" and "Related Table/Query" seem to be correct, although again I can't figure how polarity would be a factor in Type 1 forms.

My bizarre "solution" to this is to Compact/Repair then to temporarily add the primary and foreign keys to this relationships. After adding the keys, the subdatasheet appears (although the property box still stubbornly reports [Auto]), I delete the keys from the relationship and the subdatasheet/relationship remains. This don't seem write.

- Lumpy

[ADezii]

Is that important in an indeterminante Type 1 relationship and are you referring to the "Child/Master" fields in the Properties box?

Regarding the "Child/Master" jazz, when I enter the name of the table in the "Subdatasheet Name" field, the child and master fields fill in automatically, only each table has the same name for the fields I am linking so I don't know which is child and which is master. In the Relationships diagram, the tables I've selected under "Table/Query" and "Related Table/Query" seem to be correct, although again I can't figure how polarity would be a factor in Type 1 forms.

My bizarre "solution" to this is to Compact/Repair then to temporarily add the primary and foreign keys to this relationships. After adding the keys, the subdatasheet appears (although the property box still stubbornly reports [Auto]), I delete the keys from the relationship and the subdatasheet/relationship remains. This don't seem write.

- Lumpy

Can you Post a subset of the data, the Names and Data Types of the Primary and Foreign Keys, Table Names, etc. I'll reproduce your Database on a smaller scale and find out what the problem is, hopefully. It really cannot be that complicated, and I think an answer will be probable once I have the above requested information.