Ok here is my setup. first off im i kinda newbie so be kind. i am runing
just a basic access 2000 database. there are three tables, customer
information, workorders, and calls.
the customer and workorder are linked by the customer number and the callse
are linked to the work orders by work order number. the work orders are set
up rather simple and the calls are set up with two types of calls estimate
call and pickup call. i need to set up a query that will pull the
customer.customer_name, customer.phone_number, workorder.work_order_number,
workorder.estimate_amount. if there is a estimate amount is set and no est
call has been made. i cant get this to work in a simple query. it wont let
me pull anything unless i have a record in the calls table linked to the
work order.

would a way be to set it up so that if a check box it checked in the work
order for a est required that it automaticaly creates the records for the
calls and just not seting a date on them and query by the date field? if so
how would i go about doing this. thanks for any help or pointing me in the
right direction

chuck