Results 1 to 2 of 2
Feb 3, 2013, 03:54 #1
- Join Date
- Nov 2006
- 0 Post(s)
- 0 Thread(s)
Update foreign key values in parent table
I have a member table that has all the standard info (name, address, phone number, etc.) and then I have foreign key ids referencing the related gender, country of the member
When I'm writing an update sql statement, I want to update the gender and country ids in the member table by entering their corresponding value in both the gender table(eg.male/female) and country table(eg.ireland/england/france/etc.)
I'm doing this as I want it to make sense when entering values rather than entering numeric data.
If anyone knows how this is acheived that would be great.