Hi,
I am writing a small stored procedure function that look up for parent table which located in difference database in INSERT TRIGGER. VFP return ERROR (cannot close table during trigger) once i try to issue USE myparenttable AGAIN SHARED IN 2

How could I lookup other table in trigger?

Thank yuo