Thanks Karen and all I can just use a Rule, funny that PK's are allowed but FK are not.
I must be ahead of my time... LOL Marc From: [email protected] Sent: Tuesday, March 16, 2010 12:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Temp Tables Marc: I just tried it here and I get the same error message, that the referenced table does not exist. So I think FKs are not allowed on temp tables. But I'm with other posters -- I have never even thought of creating an FK on a temp table. Since you obviously need to write code to do something with the temp table, just write one line of code that checks that the FK data is in the PK table. Karen I did Unload structure for InvoiceHeader in RRBYW14 Change the table name to IHTemp then ran the code below. I get errors when Adding the FK's Either I am missing the nose on my face or FK's are not allowed on Temp Tables? Marc
