Hi !! Hi gopala krishna !! Answer: Select itemid from each table and collect data accordingly... Use find method() Thanks Somnath Jana
gopala krishna <[EMAIL PROTECTED]> wrote: hi every one, I am trying to get the data from two tables that i want to insert in another table. For example i have created table2(itemid, color, size, warehouse) now i want to get the data from InventTable, InventColor,InventSize, InventLocation and insert the same into new table. How can i do that. --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. --------------------------------- YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/