7 replies
by timwalsh
When you create a relationship between two tables you are saying that xyz field in table 1 is the SAME as the xyz field in table 2. This IDENTICAL field is what relates the 2 tables to each other. ALL parameters for the fields must be identical including the name. The error you are getting is the database essentially saying: "I can't determine how these two tables relate to each other because they don't have anything in common."
A simplistic example: Employee database
Table 1 fields: Employee ID, Employee Name, Home Address, Montly Salary
Table 2 fields: Job Title, Yearly Salary, Work Location
Both the Monthly Salary filed and the Yearly Salary field are designed alike but there is obviously nothing in common between the 2 tables (yes they are related indirectly, but the database has no way of determining this). Thus no definitive relationship can be determined.
Hope this helps.
by jgreer
by john_wills
by jgreer
by john_wills
by john_wills
by jgreer
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending