Thank you Patrice - the temp table is something I haven't considered. I am reading the documentation on this right now.
I have a question though, what do you mean with
for each tt :
/*DO what you want*/
What goes in there? The display / output?
Thank you, that hass given me an output.
There is an issue though, it is picking up ALL orders, regardless of if they are related. i.,e Order.Number and Previous Order Number.
It is just picking up Order.Number + Order Number + Order Number.
Ideally it needs to:
Finds Order Number -> find...
Thank you Marco,
You mean like this?
I tried this and it doesn't work? IS there something I am missing?
Also, what do you mean with "Infinite loop" How do I exit it, if I encounter it with this problem?
Like you said, not my design. I agree with you.
I am looking for the code that is the right combination of FOR EACH, FIND or IF Statement that will concatenate the data in the way I explained.
I understand your concern but there is only a maximum of of 5 or 6 orders not 2k. No...
Hi I am new to this. Can you please help me:
I have a database and I need to "concatenate records" based on fields in a table.
I need to be able to find the first "Order ".
Then be able to find all the other...