Relationships

BDawg04

Registered User.
Local time
Yesterday, 23:21
Joined
Jan 6, 2005
Messages
21
OK. I'm not real sure how close I am on this. I have a feeling I'm not too close so I was hoping I could get some help. I have a database with 11 tables. These can be seen in the screen capture attached. For the 'Action Taken' table there are 10 fields for 'Departments Involved', 15 fields for 'Memo Sent To', and 15 fields for 'Job Title'. The 'Departments' table is linked to 'Departments Involved1', the 'Memo Sent To' table is linked to 'Memo Sent To1', and the 'Job Title' table is linked to 'Job Title1'. All the other tables are showing the fields that are in that table. When I enter a record and try to go to a new record it gives me the following error message.

"You cannot add or change a record because a related record is required
in table "Background Information'."

I'm not sure what to do about this. I'm sure there is a simple solution but I don't know what it is. I am pretty new to Access (this is my third week on the job) and a little confused on some things. I would appreciate any help you could provide.
 

Attachments

The relationship between Action Taken and Background Information is 1-1 and Background Information is the parent. Therefore, whenever you add a row to Action taken, the Official Citation number MUST already exist in Background Information.

You have several problems.
1. Column/Table names should not contain special characters or embedded spaces. You will have trouble with these if you use VBA.
2. All tables should have unique identifiers. Response Subform does not.
3. It is quite possible that the relation problem is caused because you have not defined the correct pk for one of the tables and the relationship is actually 1-many.
4. You have multiple repeating groups in Action taken. I can't see the whole table but you mentioned them yourself in your post. Whenever you have more than one of something, you have many. So, all those fields that end in numerical suffixes actually belong in at least one separate table. Possibly more depending on their relationships to each other.
 
Thanks for the tips. I'll play around with it and see what I can come up with.
 

Users who are viewing this thread

Back
Top Bottom