A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form Trouble



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 08:00 PM posted to microsoft.public.access.forms
stardrift
external usenet poster
 
Posts: 2
Default Form Trouble

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.

  #2  
Old April 23rd, 2010, 08:36 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Form Trouble

On Fri, 23 Apr 2010 19:00:18 GMT, "stardrift" u59573@uwe 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
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.
--

John W. Vinson [MVP]
  #3  
Old April 23rd, 2010, 09:48 PM posted to microsoft.public.access.forms
stardrift
external usenet poster
 
Posts: 2
Default Form Trouble

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.

  #4  
Old April 23rd, 2010, 11:14 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Form Trouble

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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.