Master-Child Link Error Object or class does not support the set of events

[shuddle]

I have a master form "Fm_Vehicle_Data" with the primary key "VIN" and a subform "Subfm_Accidents" with the primary keys "AccidentVIN" and "Accident Date".



I have linked the forms with the Link Master Fields being "VIN" and the Link Child Fields as "Accident VIN"

They are in a one-to-many relationship without Enforce Referential Integrity.

When I try to enter data in the subform of a record I get this error "The LinkMasterFields property setting has produced this error: Object or class does not support the set of events."

Can you help with this?

[shuddle]

Correction Child link is "AccidentVin" no space

[June7]

Don't set up a compound primary key. Set this field pair as a compound index. This dependent table does not even need a primary key although wouldn't hurt to have an autonumber field as key. Accident VIN just needs to be a foreign key field.

[shuddle]

I'm not sure what you mean by compound index.

I have changed out the dual primary keys to an autonumber primary key. I've also changed the AccidentVin to Index to Yes (Duplicates OK), but I'm still getting the same error.

[Welshgasman]

If accidentvin was your primary key, then you should not have it set for duplicates.

[mike60smart]

Hi
Can you upload a copy of the Db?

[shuddle]

Fleet Database_Test.zip

I have attached a sample database. When I go to the Data Entry Form and try to add data into the subforms I get the following error message.

[mike60smart]

Hi
It is difficult to know where to start as there are so many things wrong with your Relationships and table designs.

Can you give an explanation as to the purpose of the database?

[shuddle]

That's not good to hear.

The purpose is to have all the data that relates to a vehicle to reside in one place for data entry and easy viewing. There could be multiple users. There are monthly VORs. There could be multiple Recalls, 3rd Part Inspections, Modifications and Accidents.

I guess if it is as bad as you indicate I could start over.

[davegri]

I didn't have any trouble at all editing record 1 or adding record 2.