Help trouble shooting a related records issue

[Bkper087]

I am creating a donations tracking database. I have a master table that is populated from an excel file generated by our internal systems. I cannot change this file. I have a second table that is serving as an extension of the first table in which I can enter pertinent information when new donations are received. This ultimately will allow me to track what I have processed vs. what is in my organization’s database. I really want to keep these tables separate so I can in theory update the primary table without sacrificing the information in the related.

I have created a form that is populated a query of the two previous tables. They are related enforcing referential integrity/ cascade delete/ Join all from the Primary Table and only include the related table information that matches. I have a sub-form that includes the data in secondary table. The sub-form and master form are linked using the ID field per the properties table.

I have an after insert macro created that inserts a table in the secondary table every time a new record is created.

The issue I am having results when I attempt to create a new record in the form window. I can enter a name in the primary table form and save okay. However, if I attempt to enter information in the sub-table I get the error, “You cannot change or add a record because a related record is required in the [primary table]”



Any ideas of what’s going on?

[June7]

Are you sure the main record is committed to table before entering related record?

Are the Master/Child Links properties set to appropriate PK/FK fields?

[Bkper087]

I assume committing the main record to the table is saving the form? I have been doing that prior to moving to the sub form.

[June7]

Saving the form or do you mean saving the record?

With bound forms and proper form/subform arrangement, no code should be required. So I really don't understand what purpose the macro serves.