Database Schema options....Need some advice

If this isn't that clear let me start off by saying sorry!

I'm developing a database driven website and this is the first time I'm doing it from scratch and alone so I could use a little input.

The specific question I have is about linking tables in MS Access 97. If I have a table named Scheduale and it has a field in it named Location which is linked to a Locations table which has an ID and Location field and the Location field can be either Home, Away, Tour, etc..

Like So:

-----------         -----------


|Scheduale|         |Locations|

|---------|         |---------|

|ID       |         |ID       |

|Location |---------|Location |

|---------|         |---------|

No when I link the Scheduale.Location field should I link it to Locations.ID or Locations.Location? What are the pros and cons of each? I understand linking it to the ID will just give me numbers and I'll have to consetently keep looking up wich number is for which value but I would think this will make data checking easier. Any Help will be greatly appreceiated.

Jonah Received on Tue Jan 08 2002 - 21:50:52 CST