John W. Vinson wrote:
Hi, I am new to access but not to dBs. I need some help creating a form. I
have a table that contains customer information and generates a unique
[quoted text clipped - 8 lines]
custID values in the relationships window. Any help would be greatly
appreciated.

A relationship doesn't automagically transfer anything: it just prevents the
entry of an invalid CustID.

What I think you want to put onto the Customer form a Subform based on the
Jobs table, using CustID as the Master/Child Link Field.

I think that this could work, however I also have another table that i need
to fill in data from. Let me explain in as much detail as i can and see if
you have a good solution.

There are 3 tables that I am trying to work with: Customers, Jobs, Services
Customers contains info about each customer name, address, billing info stuff
like that.
Services contains info about the different services that my company provides,
cost, est time, name ect
Jobs is supposed to be a list of every service that a customer has ordered.

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.

again any help will be very appreciated.