Error

[tabbycat1234]

I revised a program. I have the main form then have have tabs that are related to that form with a one to on relationship.

I can enter information on the main page and the program will accept it just fine but when I go on into the other tabs to enter information that is linked to the main screen I keep getting this error.

"You cannot add or change a record because a related record is required in table 'main information'



Can someone please tell me what is going on.

[boblarson]

Make sure that you don't have the table that your subform is updating in the recordsource of the main form and don't have the mainform's table in the recordsource of the subform.

And if that doesn't take care of it, make sure you have your relationships set properly (if necessary, post a screenshot of your relationships here - upload it here, not some photo sharing site on the web as those are blocked by my workplace, as well as for other people).

[tabbycat1234]

Here is a screen shot of the relationships and a screen shot of the tabs that I have set up under my form.

Please let me know if I can post anything else that will help resolve this issue.

Thank You

[boblarson]

1. Why do you have system tables in your relationships? They should NOT be there. Unlink them and delete them from your relationships.

2. I see a link going down to a table which is not visible. So, delete the system tables (the ones that start with MSys) and then move things around so they are visible.

3. What is the record source for your main form? So, I am assuming that the main form has the table MainInformation as the record source and then you have SubForms for each of the other tabs which are based on an individual table. Is that correct?

[rpeare]

Hah I was just in the process of writing that exact thing mr larson.

I suspect that the subforms on the tabs are not correctly linked to the parent (main information) table so that when you try to add a record it's trying to enforce a relationship but can't find the parent record because your subform is not correctly applying the parent PK to the child item.

[tabbycat1234]

Here is pictures of the relationship after I deleted all the relationships in the MS files and moved things around.

I am also posting a picture of my main screen. This is what I have everything linked to.

Thanks

[rpeare]

I'm assuming each one of your tabs on your tabbed form is actually a subform and that each subform has, as it's data source, a different one of your tables. If that is the case, are each one of these subforms correctly linked to the datasource for the MAIN form you're working with. If it isn't whenever you try to create a new record you're going to get an error message (because you've got your relationships set up) that there is no parent ID. You have to link your MAIN form to all your SUBFORMS correctly or you're going to orphan a lot of data at the worst or not be able to add any data at all.

[tabbycat1234]

Is there a good tutorial that I can view to make sure that I have my parent child relationship set up properly