Problem solved, I think. I looked at everything in my form and found that under properties, the many to many was selected, not one to many. Tried a test case and found that when I create a form with one table the default is one to many, but when I add the second table it goes to many to many. Is there somewhere that a default value has changed. Tom Hart
________________________________ From: TOM HART <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, December 30, 2009 1:06:15 PM Subject: [RBASE-L] - Re: Unusual error message I have no variables in the form Tom ________________________________ From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, December 30, 2009 1:00:33 PM Subject: [RBASE-L] - Re: Unusual error message Check your variable typing and whether you have inadvertently named a variable the same as a column in one of the tables. Albert. TOM HART wrote: > I am using the latest update of 7.6 and have run across an unusual error > message. > I have a form with the driving table being Customer information from that I > have an enhanced tab with 2 tabs, one for inventory and one for sold. > I can add only one of the tables either for inventory or sales and it will > work fine, if however I try to add the second table that is where I get the > error message. > Case 1 sales first, inventory second- "Error- invalid currency value 2418" > Case 2 inventory first, sales second- "Error- invalid date value 2418" > I have done this in the past with no problem, whats up? > Tom Hart
