I want to use the value from a form field in programming to do another lookup.
E.g. the value of the field companyid for one record is ‘5’
I am doing a look-up using the sc_select() macro on the company_data table and have the following query but I want to know how i put the value of the field in the function? Am I making sense?
This is what i have so far.
sc_select(company, “select * from company_data where '”…"’");