I have a web form that enters data into a table, wo_main,
using an insert query. When submitted the form also
inserts the same wo_number into another table,
wo_combo_body. wo_number is the primary key for both
tables. The insert statement is on the form confirmation
page. Below this I have a select query, using an INNER
join selecting w_number from both tables. I want to use
the wo_number from wo_combo_body as a hyperlink to a form
that updates the record with the wo_number that was
inserted into the wo_combo_body table. Basically, I need
to use a parameter such as wo_combo_body.wo_number
= '::wo_combo_body.wo_number::' in the WHERE clause, but
I can not get it to work with the INNER JOIN. I have
tried WHERE wo_main.wo_number = wo_combo_body.wo_number
AND wo_combo_body.wo_number
= '::wo_combo_body.wo_number::' but this does not work
for me. Any help would be appreciated. Thanks,
Darren