Unable To Add Or Change Record

[DigitalAdrenaline]

Hi, I'm getting the following message and am unable to locate the problem relationship or linkage.

"You cannot add orchange a record because a related record in required in table tblAssetTicker"



Just wondering if anyone had a suggestion for what control I might investigate to allow me to add data to my table. Thanks.

[ItsMe]

Apparently, you have defined constraints on your Relationships via the Relationships Window.

[DigitalAdrenaline]

Hi itsMe, Problem Solved. I had a '0' value in the Default Value field of the Data Type in my Table Design. I've now removed it and all works fine. Cheers.

[orange]

It sounds like you have a 1 to Many relationship between tables, and you are attempting to add a record to the Many(side) table BUT there is no corresponding record in the 1(side) table.

The analogy may be adding a child to a Children table but there is NO record for the Parent(s).

[ItsMe]

Interesting, thank you for posting the solution to your issue.

[Micron]

I suspect that the field with the default value was a foreign key in another table (which is, I'll admit, another way of saying there was a defined relationship). One should not have default values for FK's as there is often no match. If you had a value of 0 in the related field of the other table, you probably would not have noticed - until you started getting weird query results if it was the many side, or error messages about unique values violation if it was a one to one relationship. Also, the order in which you choose the parent/child table can cause this issue - it may be backwards.

[DigitalAdrenaline]

Hi Micron, you would be right. My field was a FK to another table. I'll take that lesson on board. That was an astute pickup. Cheers.