update another database when entering in a record

[tln]

Is there a way to enter data into a record that updates another database?
What I need to do is enter information on the amount of revenue received for
work performed, then consider the parts used on the job to then be able to
pull a job cost report. So if I used 3-gadgets, 2 widgets, & 4 watsits, how
can I enter that into the record withouth actually creating separate columns
and creating some sort of complicated query to pull a report?

 

[John Vinson]

Is there a way to enter data into a record that updates another database?

Do you mean another *DATABASE* - another .mdb file containing multiple
forms, reports, tables, queries, etc.? Or do you mean another *TABLE*
in the current database?

What I need to do is enter information on the amount of revenue received for
work performed, then consider the parts used on the job to then be able to
pull a job cost report. So if I used 3-gadgets, 2 widgets, & 4 watsits, how
can I enter that into the record withouth actually creating separate columns
and creating some sort of complicated query to pull a report?

By creating some sort of fairly simple query based on normalized
tables. Could you describe the structure of your current tables? You
certainly should NOT have a different column for gadgets, widgets and
watsits... but I have no idea how your tables are currently
structured!

John W. Vinson[MVP]

 

[tln]

A technician is dispatched to a job. He completes the job and calls in his
completion information which includes revenue as well as parts used on the
job. So the starting table includes date, tech # and various other
information as related to one job (mind you 10 techs can run 4-5 jobs each
per day) including parts or PO#'s used on the job. I need to enter those
parts/PO#s somewhere so that a job cost report can be pulled. I'm thinking
that there should be a predefined table with the parts, part # and value to
choose from such as in a Lookup column. And if there was only 1 part used,
that may work; but again there may be several of many parts used. As far as
the PO's go, we have predefined #'s so we can have the running table of those
and somehow update that "log" through the tech/customer record and once the
invoice is received from the vendor, go back and update the final amount.
Then tying all that together, pull a report to show job cost. I realize I
could update 3 tables and create a query to pull the report. But because
there are so many record updates daily, I'm trying to figure a way to update
all of this through the one table on the front end so it's more user friendly.