Hey there. I am trying to put a database together for one our groups in technology. I am trying to figure a way to have several tables with a little data to populate a service call table. Explanation:
Table 1 - defines objects or assets
Table 2 - defines responsible parties
Table 3 - defines operational explanations for asset
categories
Table 4 - logs the changes to objects in table 1, but does
not change table 1 data.
Form 1 - easy front-end for users
What I'm trying to do. I want the users to be able open the form and enter the object/asset. Then the responsible party and description auto-populate the associated form field. Then when they enter their data and save it, it will use the auto-populated data to log the change in the service call table. Essentially, tables 1-3 should be used for definition/reference.
Table 1 - defines objects or assets
Table 2 - defines responsible parties
Table 3 - defines operational explanations for asset
categories
Table 4 - logs the changes to objects in table 1, but does
not change table 1 data.
Form 1 - easy front-end for users
What I'm trying to do. I want the users to be able open the form and enter the object/asset. Then the responsible party and description auto-populate the associated form field. Then when they enter their data and save it, it will use the auto-populated data to log the change in the service call table. Essentially, tables 1-3 should be used for definition/reference.
