title: How to link multiple data tables to SQLite tables in a database?
body: <p>In C# using SQLite, I have two datatables in my application. DT1 and DT2. Using DataAdaptor "DA" and Dataset "DS" I have to linked DT1 to a SQLIte table "Analyzer"- . I wanna be able to tie DT2 to another table in the same database as "Analyzer". How do I do this? </p>
  
  <p>Do I use the same data adaptor or 2 different adaptors? Is there even a way to link tables under a common database in Sqlite? Do we use the same connection object? I'd appreciate it if someone could shed some light on to this issue? Thanks!</p>