On Wednesday 06 September 2006 16:49, WalterAM wrote: > Take a look at the thread Drew provided. > http://www.oooforum.org/forum/viewtopic.phtml?t=21632 > I will tonight if I get a chance.
I'm floundering now. I copied and pasted the SQL commands from that discussion, only changing the names of tables and fields. This is what happened: -- ALTER TABLE tblDistricts ADD CONSTRAINT fkDistrictMaster FOREIGN KEY ( DistrictMaster ) REFERENCES tblPeople ( PersonID ) 1: Table not found: TBLDISTRICTS in statement [ALTER TABLE tblDistricts] -- A bit more detective-work shows that the program is converting table names and field names to upper case before executing the commands. Short of renaming everything in upper case, is there some more sensible way around this? I can't see any user setting that might affect this. -- Rgds Peter --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
