I tried to create a form using 2 database association. The Keys to both tables are the same ie the key to Table1 is also the Key to Table2. Both keys are exactly the same in the Dictionaries. In "Edit Selection Criteria", the criteria is set as ITEM_NO_FIX=ITEM_NO and allow insert / allow update checked.

When I tried to execute the window, the message "Unable to create temporary data table" popups up. When I remove the association to Table2, the form works. It however, refuses to work when the join is defined.

Can someone point me in the right direction to get this to work in OI4.01?

Thanks

kc

Found out what the problem was.

The TEMP file already exist. Deleted it and reattach the original file and it is back in business.

kc

View this thread on the forum...