My Access database is linked to Oracle and I use query to insert data to local table but also to display some corresponding data from Oracle in the continuous form.
It was very useful when inserting manually product indexes, allows to avoid mistakes and was a confirmation of product "Active" status.
It worked very similar to Excel's vlookup, so when user insert index, after Tab press it displays read only description and status in the next two columns.
After datbase split because of multiuser access we lost that funcionality.
Is there any way to restore it?
Regards,
Michał
It was very useful when inserting manually product indexes, allows to avoid mistakes and was a confirmation of product "Active" status.
It worked very similar to Excel's vlookup, so when user insert index, after Tab press it displays read only description and status in the next two columns.
After datbase split because of multiuser access we lost that funcionality.
Is there any way to restore it?
Regards,
Michał