table relationships

[dbertanjoli]

I hope someone will be available to help me (please see attached image). I am not sure if I laid this out properly.
My main form has a listbox with names (which I exported from excel spreadsheet into tblNames) and by clicking on individual name I can select from (so far) 3 forms ( custom menubar at the top). So by selecting a name and then a form to enter let say research category after entering data and pushing the next record I get the following error message: 'You can not add or change a record because a related record is required in 'tblActivities' (please see attached image).

I would greatly appreciate any help.
Debbie

 

[David Eagar]

I think your problem is in your form design. You can't go from tbleNames to any of the 3 final forms without first selecting an activity associated with the Name