Need to put info from form "lookup" fields into main table

[ImJay]

I have a request to create a series of forms in Access that provide succeeding bits of information back to a main table. Each row of the main table describes a preventive maintenance activity from request to scheduling.

The first form (InputForm) would include three lookup fields (dept, ext, pager) from tblNamesSite based on field "name". The content of the three linked fields must be included in the MainTable to be available thereafter.

The second form (ScopeForm) would look up "WorkOrderNumber" based on "PreventiveMaintIDNumber" or "Work RequestNumber" from an Oracle database. These three fields must also be populated in the table and called up on the approval forms. And so on, and so on.....

I researched this problem and found only one possible solution (aside from the obvious, it should be on SQL server) and found the update or edit/update function. Is this a viable solution? What is the proper syntax? Should I initiate a batch event or trigger from the form?

Thanks,

Imjay

 

[BobRodes]

This is more of a forum for using databases with VB 6. You might find forum702 a better place to post this.

HTH

Bob