Originally Posted by
Edgar
With those relationships, each agent can be related to only one property. If you want your properties to be related to only one agent at any given time and also be able to assign multiple properties to any agent, then the design should be as follows:
Company: CompanyID, CompanyName
Agents: AgentID, AgentName, CompanyID
PropertyTbl: PropertyID, PropertyDetails, AgentID
You should also reconsider your naming convention for tables. The error message probably means there are rows in Agents table with CompanyID values that do not appear in Company table.