filling field from one form to another????

[Guest]

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

 

[David C. Holley]

To summarize (hint) you want to pull the information from the QUOTE and
use it for an INOVICE?

 

[Guest]

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]

So why not just add a field named txtStatus or txtType and use that to
indicate if its a QUOTE or INVOICE?

 

[Guest]

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