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
|
|||
|
|||
Still need help - on form
Haven't heard back still need help see below:
Sound like not a bad idea. It is just that 2 different people will be inputting the info and the quote person does not need to enter truck#,ticket#, and some other fields in. HOw can I handle this that the quote person doesn't see those fields but the invoice person does?????? Thanks, Barb "David C. Holley" wrote: So why not just add a field named txtStatus or txtType and use that to indicate if its a QUOTE or INVOICE? babs wrote: Your summary is correct I just do not know how to do it???? Sorry about all the detail but thought would be more helpful - hopefully. Thanks, Barb "David C. Holley" wrote: To summarize (hint) you want to pull the information from the QUOTE and use it for an INOVICE? babs wrote: I have created a form to enter records for invoicing for shipment of trucks. Below is a list of most of the field on the Invoice form ClientId, Service Date, Ticket #, cost, truck#, material, quantity, and some calculations of ex. cost*quantity of matl. There is a step previous to this (which is currently done on paper)where some companies are receiving a quote based on - matl and cost but not a truck# or ticket# it would include some(most-not all) of the fields for the Invoice Entry form. I would like the existing form (Invoice Entry) to have a drop down for a QuoteID and have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry records will have had a quoteid or a quote for them and they would need to be manually input. I am getting confused do both the QuoteForm and the Invoice Entry form have to have the same field names ex. cost, quantiy, etc. and how can it fill for only some of the records and how can I let the user input for the other records. Do I have to go through ALL of my calc. and put the form name in front of all ex. cost fields??? The common field would be quote id but not all the Invoice Entry form and tried to do an outer join for the query for the form between the two tables. It doesn't like the outer join. thought i wanted all records for Invoice Entry table even if don't have a quote in the Quote form. Not sure how to do this all Please help thanks, Barb Was this post helpful to you? Why should I rate a post? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Search facility | tezza | General Discussion | 13 | February 18th, 2010 12:26 AM |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |