Michel, No problem with assignments 1, 2 and 3. However, lookups in expression builder will ALWAYS result in the lookup value. Since you have lotobar as the result of .vLotoBar (the result of a lookup), your user will NOT be able to change the value of lotobar to anything else but the result of the lookup value. It isn't a problem if that's what you intend and as you say, it works fine.
Claudine -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michel et Carole Sent: Saturday, February 21, 2009 1:17 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Form expressions builder In some of my forms I use a columns name as a variablename and variable expression in the form expression builder. Form : RapportGerant Main Table : Somaire_vente_depo 1 : DATE vDateRapJour = DateJour 2 : TEXT vgerant = Gerant 3 : CURRENCY Location = .vtotlocation 4 : CURRENCY vLotoBar = LotTBar in LotoVi where DateJour = .vdateRapjour and gerant = .vgerant 5 : CURRENCY Lotobar = .vLotoBar - Location is a column in table RapportGerant - LotoBar is a column in table RapportGerant -DateJour is a column in table RapportGerant -Gerant is a column in table RapportGerant It works fine and refreshes columns automaticly Is that a good practice or is there a better way to refresh? Thank You Michel Séguin
