Data merge

  • Thread starter Thread starter Burt
  • Start date Start date
B

Burt

I have a database that I use for estimating projects and managing jobs. I
want selected estimates to populate specific fields and allow for additional
information/records in production management. I have been trying a select
query and lookups but I cannot seem to get the right combination to allow for
a merge and additional information. Any suggestions or templates that
addresses this?
 
I have a database that I use for estimating projects and managing jobs. I
want selected estimates to populate specific fields and allow for additional
information/records in production management. I have been trying a select
query and lookups but I cannot seem to get the right combination to allow for
a merge and additional information. Any suggestions or templates that
addresses this?
Click to expand...

Please post some details on your tables, their relationships, and the SQL of
the query you're trying to do. It's all but impossible for anyone to guess
what problems you might be having based on your post here... and that's of
course all that we can see!

John W. Vinson [MVP]
 
John W. Vinson said:
Please post some details on your tables, their relationships, and the SQL of
the query you're trying to do. It's all but impossible for anyone to guess
what problems you might be having based on your post here... and that's of
course all that we can see!

John W. Vinson [MVP]
Click to expand...
I have two tables which are structured the same (the estimating table was a
copy of the job table). I am trying a one to many relationship between the
two by a field that uses the estimate ID (key) and a field that calls that
ID. When I enter an ID number in the jobs table, I am trying to get about
five fields to bring data from the estimate to the jobs record. Plus, I need
to be able to change or add to job data without affecting the estimate table.

I do not think I am structured right but cannot see which way is the right
way. Does this help?
Thanks allot

SELECT Estimates.[Est ID], Estimates.CustomerID, Estimates.Description,
Estimates.DueDate, Estimates.QTYOrdered, Estimates.QTYOvers,
Estimates.QTYUnders, Estimates.[Final Width], Estimates.[Final Lenght],
Orders.OrderID, Orders.DueDate, Orders.Estimate, Orders.QTYOrdered,
Orders.QTYOvers, Orders.QTYUnders, Orders.[Final Width], Orders.[Final
Lenght], Orders.Comment
FROM Estimates INNER JOIN Orders ON Estimates.[Est ID] = Orders.Estimate;
 
Back
Top