Fred As long as the common column names are the same you don't have to do anything. One other note is that if you have more than one common column, those columns must also match Buddy
-----Original Message----- From: Fred Antrobus [mailto:[EMAIL PROTECTED]] Sent: Thu 12/19/2002 1:56 PM To: [EMAIL PROTECTED] Cc: Subject: [RBASE-L] - Three table Form problem I am using the latest inline patch of R:Base for 6.5++ I am creating a form based on 3 tables: Employees BillingRates Hours There is a linking column of empcode (text 3) in all 3 tables. The Employees table is the driving table. For table (1) employees I create the variable f_empcode = empcode For table (2) BillingRates I create the variable EmpCode = .f_EmpCode For table (3) Hours I create the variable empcode = .f_EmpCode I get the error message "The variable name is in use, Use another name" This worked in previous versions. The point of setting the variable was to be able to pass the EmpCode from the Employees table to the billingrates and Hours tables to maintain the linking column values. I made sure that I had the current table set correctly for each table in the form when I tried to create the third table in the form. The form works fine with just two tables. TIA, -- -- Fred Antrobus <[EMAIL PROTECTED]>
