I have created a form containing a subform in datasheet view.
This is my ERD.
SELECT ProjectToParticipant.ProjectID, Participant.ParticipantID, Participant.NameFirst, Participant.NameLast, Participant.NameMiddle
FROM Participant INNER JOIN ProjectToParticipant ON Participant.ParticipantID = ProjectToParticipant.ParticipantID
SELECT ParticipantTestScores.ParticipantID, ARTest.TestName, ParticipantTestScores.Score, ParticipantTestScores.Right, ParticipantTestScores.Location, ParticipantTestScores.Motion, ParticipantTestScores.BodyPosition
FROM ARTest INNER JOIN ParticipantTestScores ON ARTest.ARTestID = ParticipantTestScores.ARTestID;
The master and child link fields are: ParticipantID
To add a test to the datasheet the user drops the list to select a test.
When the test name is selected I get this error.
1. Why am i getting this error? When I click help it says the table is locked. Which table? I have not locked any table and no tables are open in another window.
2. When I close the form and look at the ARTest table a new record has been added.
The objective of the datasheetis to add a record to the ParticipantTestScores table.
- When the user selects a test name the key for that test should automaticly populate ParticipantTestScores.ARTestID
- The key for the participant should populate automaticly populate ParticipantTestScores.ParticipantID
the screen shots are too small for me to read; but what strikes me is that you have a subform select....and that select statement has a join....which may be rendering the underlying query to be non updateable...
when you plug in a subform - the wizard walks you thru the set up...and one doesn't need a select statement.....
I think if the screen shot is clicked the enlarged view is presented.
Originally Posted by NTC
...but what strikes me is that you have a subform select....and that select statement has a join....which may be rendering the underlying query to be non updateable...
This is a simple join to a look up table to get the test name. Would that actually cause Access to fail?
Originally Posted by NTC
...when you plug in a subform - the wizard walks you thru the set up...and one doesn't need a select statement.....
I would like a deeper understanding of how Access works than blindly following the wizards. Using the UI to update or add a row in a normalized DB should not be that is easily done in code and not have to rely on a wizard.
I really want to understand why Access is behaving in this way.