|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Relational DB Design
Hey all!
I'm new to relational db design and I've run into a problem. Here is the scenario: I have a table that contains three fields (well, it contains more than that, but three of which this problem is concerned with). Each of these three fields can have one of two values. However, trying to keep data integrity and reduce redundant data, I am unable to relate these fields to a table. Table1: tblID <pk> ... <other fields> Field1 Field2 Field3 ... <other fields> Table2 tbl2ID<pk> Field4 Field5 The idea is that Field one can equal the contents of tbl2ID 1 or 2 (being the two possible values) as well as Field2 and 3. I've tried linking tables but it still doesn't produce a unique way for me to display the data in fields 1-3 in my code. Is this as clear as mud? Ark |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Relational DB Design |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|