homepage Welcome to WebmasterWorld Guest from 54.227.171.163
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
database design
relationships between cells
Scally_Ally

5+ Year Member



 
Msg#: 34 posted 3:48 pm on Sep 15, 2005 (gmt 0)

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

5+ Year Member



 
Msg#: 34 posted 4:32 pm on Sep 15, 2005 (gmt 0)

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

10+ Year Member



 
Msg#: 34 posted 5:32 pm on Sep 15, 2005 (gmt 0)

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

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 34 posted 6:36 pm on Sep 15, 2005 (gmt 0)


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

5+ Year Member



 
Msg#: 34 posted 10:33 am on Sep 16, 2005 (gmt 0)

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved