Hi,
I have created a lookup wizard for a MS Access query. The lookup was pulled out from another table with different linked field and displayed field. It works fine.
The problem occurs when I have transfered my database to Oracle. When I create same lookup list for the view. The lookup display nothing. I have followed your suggestion you posted before regarding similar problem. To comment out
'On Error Resume Next in the edit.asp file. I got error message
Type mismatch
/include/HDB_PHYSICAL_ARRAY_LIST_QUERY_aspfunctions.asp, line 686
I have checked the type within the View and table, it seems fine, could not see the problem.
What I basically has is a query pulled from several table and it contains a User_ID, I want User to be able to change the User_ID using dropdown list which it display as User_Name and linked by UserID from the User Table.
Thanks in advance if you can give me some advice.
