the main table for the database is called order entry. This form as well as others reports to this table. In the table resides job number which is the primary key and is autonumbered. We have an estimating program that is access version? based that contains all the customer history, invoice etc. I have linked tables from my database to it to eliminate duplicating entries ie... customer info etc.. so the query for this form has two tables in it now. One order_entry not a linked table and customer1 which is a linked table.

Gary