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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|