relationships

[maxmangion]

If I have a table "tblContinents" with just two fields ContinentID and Continent and I have another table called "tblCountries" with three fields CountryID, Country and Continent.

After reading several articles, i decided not to make the Continent field in the tblCountries as a lookup field but rather I will do that at form level via a combo box. In such situation, since i am not creating a lookup field at table level, do you think that it is necessary to create the relationship between the two tables in the "relationship window", or shall i just leave it as it is, and if the need arises i will create such "relationships" in queries?

Thanks very much.

 

[orna]

You don't have to create a relationship between the tables.

 

[neileg]

Why not? There's no downside to defining the relationship.

 

[mikebaldam]

its worth doing just for cascade updates/deletes in the DB...