Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a circular reference within my data model that I'm having trouble resolving.
Based on forums I've researched I've created a link table but this hasn't resolved my issue.
I've attached my model as a reference, any assistance is appreciated.
thanks
James
ifHi James
I marked your circular reference for better understanding.
I hope this will make it more easier to solve the issues.
The problem is that vContracts, vSite, vVehicles and ContractLink table create a circular reference.
E.g. if you can drop vehicleid from ContractLink table it would be solved, also just rename the field from "vehicleid" to "vehicleid_ref" will solve it. I don't know your requirements so let me know if this already helps you.
Regards
Ronny
thanks Ronnie
Better break the link between the tables Contract_link table with any of the adjacent table