Fred, I think that your variables are superfluous, (and always were in earlier versions, too!)
Unless the column names for the linking columns were different from one table to another, the form is already making all those assumptions for you. On entry of new rows into the subordinate tables, the common column gets the value of the top table. Try removing those expressions from all three tables, and see if your form works. Bill On 19 Dec 2002 10:56:37 -0800, Fred Antrobus wrote: >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]>
