Thank you Peter... again.. :)
Which would be the source field and which the target field?
Karl
On May 1, 2010, at 3:22 AM, Peter Lind wrote:
On 30 April 2010 20:49, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> wrote:
No, please confuse me. I need to know this stuff.
@Peter thanks for that introduction to foreign keys. Since my
productoptions
table is based off of items in products, optionGroups and options,
would I
use foreign keys for this?
If I read you correct, your productoptions table is basically a lookup
table and as such all your fields should be foreign keys. Because,
each field is a reference to another table - and it's vital to data
consistency that they cannot point to a row in a table that doesn't
exist.
--
<hype>
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
Flickr: http://www.flickr.com/photos/fake51
BeWelcome: Fake51
Couchsurfing: Fake51
</hype>
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
