Consider posting your solution...

Someone in the future may be looking for an answer and your solution may be
it.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"mls via AccessMonster.com" u55943@uwe wrote in message
news:a356f690381fe@uwe...
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