New user, so forgive the question if basic.
I have a nested table inside my main table in order to include tasks on various projects. The problem comes when I try to submit the form (connected to Access database) with more than one task. Apparently, the second task doesn't connect with the primary key--when I made the key field visible I can see that the second (and subsequent) task empties the field that connects to the primary key. Even when I run a script that fills in the field, submitting the form empties this field again.
Am I missing something basic that prevents second (and subsequent) repeating sections in a subdatasheet table from connecting to the main database's key field?