Hi
Having a problem setting up master/detail relationship in PHP. The tables are created via SQLPlus in an Oracle database, follows:
Master Table : Table 1
category-code key
category-desc
obsolete-ind
audit date/time/user
Data sample : 'A10', 'A10 Name', 'N', '20070801 154500 Tony'
'A20', 'A20 Name', 'N', '20070801 154519 Tony'
Master/Detail Table: Table 2
standard-code key
standard-desc
std-smv-value
std-factor-ind
std-enhanced-value
audit date/time/user
Data sample : 'C70', 'C70 Desc', '135.789', 'L', '710.455', '20070814 160729 Tony'
'C75', 'C75 Desc', '95.176','S', '366.182', '20070814 152914 Tony'
'C80', 'C80 Desc', '41.004','A', '655.201', '20070814 160412 Tony'
Master/Detail Table : Table 3
category-code key
standard-code key
element-code key
std-element-value
audit date/time/user
Data sample : 'A10', 'C70', '014500', '216.189', '20070819 101210 Tony'
'A10', 'C75', '014510', '493.276', '20070819 101214 Tony'
'A20', 'C70', '014520', '627.304', '20070819 111216 Tony'
'A20', 'C80', '014520', '881.404', '20070819 011219 Tony'
Detail Table : Table 4
element-code key
element-desc
audit date/time/user
Data sample : '014500', 'Stay Pole AAA1', '20070810 094633 Tony'
'014510', 'Stay Pole X4550', '20070810 094634 Tony'
'014520', 'Stay Pole AA899', '20070810 094635 Tony'
'014530', 'Stay Pole X4177', '20070810 094636 Tony'
All tables have been set with primary and foreign key constraints.
Problem is,
When linking the tables in Data Sources (PHP projects) only the first column (eg. category-code) is shown as primary key in Table 2/3. Unique key/s combinations (Table 1 - category-code, Table 2 - category-code/standard-code, Table 3 - category-code/standard-code/element-code, Table 4 - element-code). When moving from 1 list to the next level list, data shows up incorrectly.
Any suggestions welcome !!
Thanks,
Tony
