|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
March 13th, 2005, 03:23 PM
|
|||
|
|||
One to Many relationship-it doesnt work
Hi,
im trying to do a one to many relationship for the database attached. but it does not seem to work, so can you guys help me out. I want time in table 1 to have a one to many relationship with time in table 2. And stylist ID in table 1 to have a one to many relationship with stylist ID in table 2. Thanx can u guys please help
|
|
#2
March 13th, 2005, 04:38 PM
|
|||
|
|||
|
Not to sound like the untrusting sort, but I doubt many people are going to download a .zip file.
You'd have a better chance of being helped if you just posted the text of your CREATE statements.
|
|
#3
March 13th, 2005, 07:28 PM
|
|||
|
|||
|
I agree...
Quote:
still, here's an example so you'll figure it out yourself! Table 1 (stylists): IDstylist [int] name [varchar] ........ ........ ........ Table2 (Sons): IDson [int] name [varchar] IDstylist [int] (FK) --> Each stylist has zero or more relatives ......... ......... ......... If you want to create a one to many relationship, just place the parent Pkey in a child field as an FK. That way, the each stylist may have as many sons as you want! Good Luck ANibal.
|
|
| Viewing: Dev Articles Community Forums > Databases > Database Development > One to Many relationship-it doesnt work |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
