I have to read and write to an Access database.

I started out by defining views of all the tables in the Access database. This is working fine.

Now I would like to define some persistant relationships between the tables.

Do I use alter table to do so?

I tried doing it interactively (using modi data) but that didn't seem to lead anywhere...