Form Trouble

[stardrift]

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
customer number, custID, and I also have a table that contains a list of jobs
ordered by each customer. In the jobs table there is a custID which I want to
have a many-to-one relationship with the custID in the customer's table. So I
created a form that I want to select a customer from a drop down menu, which
contains Names and Addresses, and have it fill in the custID from the
customer table into the jobs table. As it is currently set up I can select
customers but it does not auto fill the custID. No data is transfered between
the two tables, even though I set up a many-to-one relationship between the
custID values in the relationships window. Any help would be greatly
appreciated.

 

[John W. Vinson]

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
customer number, custID, and I also have a table that contains a list of jobs
ordered by each customer. In the jobs table there is a custID which I want to
have a many-to-one relationship with the custID in the customer's table. So I
created a form that I want to select a customer from a drop down menu, which
contains Names and Addresses, and have it fill in the custID from the
customer table into the jobs table. As it is currently set up I can select
customers but it does not auto fill the custID. No data is transfered between
the two tables, even though I set up a many-to-one relationship between the
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.

 

[stardrift]

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.

 

[John W. Vinson]

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!