Error 2801:
1. In Designer;
2. After Pack/Reload
3. After Disconnect/Shutdown/Restart
4. In Designer again
5. Replace the PROJECT command with CREATE TEMPORARY TABLE for TransTest
********************
Here's the UNLOADed structure of the referenced table:
CREATE TABLE `glCode` +
(`glCodeID` INTEGER NOT NULL , +
`glCodeParent` TEXT (4) , +
`glCode` TEXT (4) NOT NULL , +
`glDesc` TEXT (20) , +
`glSort` INTEGER )
ALTER TABLE `glCode` ADD PRIMARY KEY (`glCodeID` )
AUTONUM `glCodeID` IN `glCode` USING 10041. 1. NONUM
********************
... and the UNLOADED structure of the FKEY-host-to-be table:
CREATE TEMPORARY TABLE `TransTest2` +
(`transid` INTEGER NOT NULL +
('Value for transid cannot be null.') , +
`transdate` DATE , +
`glCode` TEXT (4) , +
`transcode` TEXT (1) , +
`transtype` TEXT (3) , +
`transnum` TEXT (12) , +
`vendorid` INTEGER , +
`transmemo` TEXT (40) , +
`ExpAmt` CURRENCY , +
`IncAmt` CURRENCY , +
`glCodeID` INTEGER )
ALTER TABLE `TransTest2` ADD PRIMARY KEY (`transid` )
********************
If there's something to see, I'm just not seeing it. Thoughts?
Bruce
