On Fri, 23 Apr 2010 20:48:25 GMT, "stardrift" u59573@uwe wrote:

So what I want to happen is an employee will fill out the customer's info,
then move on to a "Job" form in which they will select a customer from a drop
down, and then a service from a drop down, and then fill out the date that a
service is ordered, and later the date that the service was completed (date
stuff was easy). I want the form to take the custID of the customer selected
from the drop down and then take SvcID from the services drop down and put
that info into the jobs table. The jobs table will only contain the custID
and the SvcID from the customers table and the services table respectively.

Perfectly straightforward.

Base a form on the Jobs table. Put a combo box (bound to the Jobs CustID
field) on the form, basing the combo on the table of customers. Put another
combo based on the table of Services, bound to the SvcID. Have a textbox bound
to the DateOrdered and DateCompleted fields (you will want the date fields in
the Jobs table since it is information about a specific job, not about a
customer or a service).

It's even easier if you make the Jobs form a Subform of the Customers form,
since you'll get the CustID automatically without needing to select it from a
combo. Up to you though!
--

John W. Vinson [MVP]