Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 using query or vba ,transfer data from one form to

Author  Topic 

moggymorgan
Starting Member

1 Post

Posted - 2007-02-27 : 11:52:18
using a query or vba ,transfer data from one form to another,
table1 customers-form1 customer address,
table2 orders-form2 order address,
how do i transfer data from customer address to order address
yours M [/center]

nr
SQLTeam MVY

12543 Posts

Posted - 2007-02-27 : 14:05:52
What's a form?
Do you mean you have an address in the customers table and want to display it in a form for an order or want to add it to the orders table.
Normally you would display it as an option then write it from the application.

Depends on your business rules though.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -