August 4, 200520 yr 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
August 4, 200520 yr and I want this Quotation post to my Invoice...can this done? Thank! What you mean? Can you explain details by example?
August 4, 200520 yr 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
August 8, 200520 yr Author Once the cust. Quote is confirm...I want to copy all the --> Item, Description, Unit Price, Amount to my Invoice!
August 8, 200520 yr 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
August 8, 200520 yr 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
Create an account or sign in to comment