PC Review


Reply
Thread Tools Rate Thread

How to create data adapter for multiple tables (joint tables)?

 
 
Nguyen
Guest
Posts: n/a
 
      16th Jun 2004
I use sql builder to create a dataadapter. If there is only one table, the
insert/update/delete commands are automatically created successful. However,
if I build a select command based on multiple tables, I got errors:
"insert/update/delete commands can't create automatically for multiple
tables...?". Any of you know how to accomplish this?

Any suggestions are greatly appreciated.

-V


 
Reply With Quote
 
 
 
 
William Ryan eMVP
Guest
Posts: n/a
 
      16th Jun 2004
Check out the datarelation
http://www.knowdotnet.com/articles/datarelation.html

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
"Nguyen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I use sql builder to create a dataadapter. If there is only one table, the
> insert/update/delete commands are automatically created successful.

However,
> if I build a select command based on multiple tables, I got errors:
> "insert/update/delete commands can't create automatically for multiple
> tables...?". Any of you know how to accomplish this?
>
> Any suggestions are greatly appreciated.
>
> -V
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a report from multiple tables/merge data in multipletables? =?Utf-8?B?S3lsaWU=?= Microsoft Access 6 18th Aug 2005 12:38 PM
How do I create a form to enter data to multiple tables? =?Utf-8?B?QmV2Qg==?= Microsoft Access Forms 2 5th Jul 2005 07:05 AM
Access 2000 Create Multiple tables depending on a data field chang =?Utf-8?B?QkY=?= Microsoft Access VBA Modules 0 31st Mar 2005 10:17 PM
create multiple tables in word document from access data ChrisA Microsoft Access 0 18th Nov 2004 07:16 PM
Table Relations: linking data from multiple tables to create a single report Nashville DAS Microsoft Access Forms 3 28th Mar 2004 04:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:41 AM.