Hi all,

 

I have a database with three tables:

 

Account

AccountAddress

Address

 

These are used to describe a many to many relationship between Account and Address.

I also have a field in Account that points to a specific AccountAddress record to define the Primary Address when dealing with that account.

The relationships set up are as follows:

 

Account -> AccountAddress on the appropriate keys

Account -> AccountAddress pointing to a specific record on the appropriate key

AccountAddress -> Address on the appropriate keys.

 

Using Classic DevForce (3.6.2) and a CAB solution based on Cabana, I have a problem when I change the field in Account to point to a different AccountAddress record and delete the original AccountAddress.

 

When I save the Account record I then get an error show below:

 

 

I think this is because the persistence order or, perhaps an issue with our relationships, is wrong.

 

The error is pointing to the relationship pointing to the specific record.

 

If I save the content before deleting, then delete the original address it works but this is not an ideal solution.

 

Does anyone have any suggestions on how I can go about solving this problem.

 

Thanks

 

John