Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: open
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
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.