Somewhere I'd read about having variable values returned as column values
and I've found a case where I am not getting it to work.
The form collects multiple rows on living situations for one month. The
particular situation is based on a lookup table, and each situation has a
numeric score attached.
At the top of the form I use a combo box to collect the row ID
(nonintelligent primary key) of the lookup record. That value is returned
to a column (this works ok).
However, I cannot get the score to write to the table when the record is
saved.
Two lookups based on one lookup action (the combo box): how should this
work?
The variables I'm using are:
Table: EvLR
1. INTEGER ypid = .gvhhn (a earlier lookup: a client id from a CHOOSE in
code)
2. INTEGER eid = .gveid (the admission id for the above client id, same
method)
3. TEXT vfypname = (lname + ', ' + fname) from yp where ypid = .gvhhn
(concatenation of the name, works)
4. INTEGER vflrid = lrid (set a variable equal to the lookup record
number)
5. NUMERIC vfLRes = LRScore in DLres where val = .vflrid (looks up the
score, this works in that the correct value is captured as shown by a SHOW
VAR command after exiting the form).
6. NUMERIC Lres = .vfLres (sets the column = to the variable -- this does
not work)
The score field -- Lres -- is placed on the form. I tried placing the
variable, got it to display, but could not get the value written to the
table.
Where do I go from here?
tia
Dave Ebert
[EMAIL PROTECTED]
