database design

relationships between cells

[Scally_Ally]

hey all,

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.

Hope i have explained it well enough

Thanks

[Scally_Ally]

I know its something to do with enforcing the referencial intergrety but thats about it.

Have tried a number of ways but still cant get it to work. (and i know it is really basic thing to do aswell)

Cheers

Ally

[py9jmas]

What you're looking for is known as "foreign keys".
I don't use Access, but a google seach for "access foreign keys" (without the quotes) threw up some stuff that looks relevant.

[aspdaddy]

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 :)

[Scally_Ally]

yeah thanks guys...

there was some good information there, got what i was looking for. I hate it when i know what i want to do but dont know what the technical term for it is.

doing this working within my database will save alot of time on the programming side of things.

Cheers Ally