I am pretty new to database design for my sites and seeing as the database i use most is access i thought i would post my problem here.
Could anyone please fill me in on how to link one cell in one table to a cell in another?
I have created a table called 'headers' and within this there is a field called 'group', in my other table I have created called 'subcats' there is a field called 'header_group'. these two fields are both number fields.
Now i want to be able to make it so that every time a value in the 'group' field is changed all the entries that correspond in the 'header_group' field are also changed.
You can do it on the diagrams page, drag a line from a column in one table to a column of the same type on another table and the systemn creates the foreign keys for you. In Accesss theres no way to write FK's in SQL - I dont think so anyway :)