Creating Dynamic Array Proplem GSG...
My issue is similar in that I'm going throught the GSG for Dynamic Dropdown and on page 7 at point "5. From the Parent ID field menu, choose the ParentID column."
Once I've chosen the "Child table" (from point #4) It doesn't give me the option to select the Parent ID for the "Parent ID field:". Only the ChildID (that was established by my record sed) shows.
I've checked my DB (phpMyAdmin) and the foreign key was created and the Parent and Child tables are related. I am stuck.
Help Please!
===============================
-- Table structure for table `Child`
--
CREATE TABLE `Child` (
`ChildID` int(20) NOT NULL auto_increment,
`ChildText` text NOT NULL,
PRIMARY KEY (`ChildID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `Child`
--
--
-- Constraints for dumped tables
--
--
-- Constraints for table `Child`
--
ALTER TABLE `Child`
ADD CONSTRAINT `Child_ibfk_1` FOREIGN KEY (`ChildID`) REFERENCES `Parent` (`ParentID`) ON DELETE CASCADE ON UPDATE CASCADE;
===================================
-- Table structure for table `Parent`
--
CREATE TABLE `Parent` (
`ParentID` int(20) NOT NULL auto_increment,
`ParentText` text NOT NULL,
PRIMARY KEY (`ParentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `Parent`
--