importing

[WorkRelated]

I have a purchase order database and a job costing databases. In the purchase
order database I run a report that calculates how much £ has been spent on
each job (the form has a field for job ref)

In the Job Costing database there is a field that I manually enter the total
from the purchase order database report.

Is there anyway that I can link the purchase order report to the job costing
database so that the feilds update automatically?

Thanks in advance

 

[Arvin Meyer [MVP]]

The proper way to do it is to have all of the tables in a single back-end
database, with the tables linked to their respective front-end databases
running on each workstation. Then all you need to do is to add a link to the
proper table.

 

[golfinray]

Yes, use File\Get external data\ and enter the other database.

 

[WorkRelated]

Thanks for your help.

I can now run the report from the Purchase Order DB in the Job Costings DB
but am struggling to get the total from the report to display in the Form of
the Job Costing DB.