Quotation to Invoice!

[Questions King]

Hi, I have a new solution need your help! Everytime ask you to help, hope you don't ask me to pay you hehe.....

My solution is: I open the Quotation to my client and I want this Quotation post to my Invoice...can this done? Thank!

Quo._to_Inv.zip

[aaa]

and I want this Quotation post to my Invoice...can this done? Thank!

What you mean? Can you explain details by example?

[Søren Dyhr]

I thought you have read my private mail to you??? This is a FAQ to say the least!

Take a look at the debate in this thread ...

http://www.fmforums.com/forum/showtopic.php?tid/168000/tp/1/

It's bad mojo to copy stuff thats more or less is identical from a quote to an order. Redundancy is usually what relational designs seeks to get rid of.

Not that we managed to make the reasoning sink in with hubabubaa, but we could hope that we have slightly better luck with you. At least take a look at the movie refered to in the thread.

--sd

[Questions King]

Once the cust. Quote is confirm...I want to copy all the --> Item, Description, Unit Price, Amount to my Invoice!

[aaa]

I will try to do it in you r example.

[Søren Dyhr]

I want to copy all the --> Item, Description, Unit Price, Amount to my Invoice!

This is what I say is conceptually wrong in a relational database systems as such!!!

Manipulate the keys not the data, if what it takes -just is a re-arrangement of data already stored!!!

--sd

[aaa]

Near such, on quickly hand.

Testing.zip

[Søren Dyhr]

Near such, on quickly hand.

But who are you doing a favour here??? All seasoned developers are able to make the requested hack, but it's similar in nature to advice a newbe in stuffing data in repeaters via script. Reminding me of the La Fontaine fable about the bear that tries to prevent an insect on his masters head from doing it's business:

"Nothing is so dangerous as an ignorant friend; it is better to have a wise enemy"

The data is moved, not altered at all!!! ...a major flaw, in the relational structure.

--sd