Autofill form

[coolcatkelso]

Hiya (Access 2007)

I have two forms (Quotes) & (Workorders)

The first form quote would be stage one. The user would fill out the quote information for the customer. print it off and post, email to customer. Wait for the quote to be accepted and then fill out the Workorder, for the work to start.

What I need :-

I would like it, IF, I could click a button or sumthing and have the (Quote) information sent to (Workorders) to save the user re-typing everything out.

Now both forms have subforms where the Materials, Qty, and unit price are stored. but use different tables

Querys uses - Querys Materials
QuoteID, MaterialID etc

Workorder uses - Workorder Materials
WorkorderID, MaterialID etc

Have tried many ways to attempt to link this, but have failed everytime

If someone has a spare 5 mins, could they please look at this, and see if it can be done easily.

Cheers
CCK

Any problems loading the DB, Hold down Shift H when opening
________
LovelyWendie99

 

[LeeInEngland]

Of course that can be done.
Open the Quote, click a 'Send to Workorder' button.

Code the button to open the Workorder form and fill the next sequential workorder number.

Then select all the records from Quote Materials and seqeuentially add them to Workorder materials with the appropriate workorder number.

Hope that makes sense.

 

[coolcatkelso]

Hiya m8

Cheers the reply

Any chance of wot the code would be? Or any help with a step by step guide lol sorry, not the smartest at VB yet
________
Roll Blunts

 

[coolcatkelso]

Anyone lol
________
MUSIC FESTIVAL

 

[coolcatkelso]

Still having no luck with this.. Anyone offer further help?
________
Xxx amateurs

 

[boblarson]

This comes up frequently so there are other posts here on the forum (should you choose to use the search facility - and Google is a great tool for searching AWF by the way). But the main thing is why you don't just store them all together in the same table and have a field which converts from a quote to a workorder. It would be much simpler (and that is what is generally suggested in the other posts I believe).

 

[coolcatkelso]

Cheers for the reply

What kind of field would I need to perform a convert from Quote to Workorder and how would I do this?

I would assume I would need to create a new field in the Materials Table as an autonumber field?

As it is, Materials listed for Quotes is linked to the Material by QuoteID, Workorders for the Workorders form

So I would need to delete those fields from the Materials, and something like OrderID and include an OrderID field on Both the Quote form / table AND Workorder Table?
________
Weed vaporizers