Sorry for the confusion. You can ignore this message. I fixed this.

Thanks
orange wrote:
I want to combine master Order table and order_detail transactional table.
If my order_detail table has orders today then I want to give OrderNo
[quoted text clipped - 28 lines]
How can I achieve this?
Thanks in advance
What is it that you are trying to solve?
Do you have a database of orders and order details without unique OrderNo?

I do not understand your request- sorry.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1