chaos_09

OK, I have an EmployeeProfile (empno, empname, etc) and SalaryInformation (empno, payrate, salary, etc) table under Emp.mdb. The thing is, I want to be able to view all the records in these two tables in only one form (textboxes range from employee number to salary deductions). I also want to be able to add, edit, delete using the same form. Oh, and I'm using Data Controls too. Can anybody give me a source code on how I can link these two tables programmatically?

VBJoe

Quote:

---

Originally Posted by chaos_09
... and I'm using Data Controls too. Can anybody give me a source code on how I can link these two tables programmatically?

---

Are you wanting to do it programatically or using the Data Control?

chaos_09

Quote:

---

Originally Posted by VBJoe

Quote:

---

Originally Posted by chaos_09
... and I'm using Data Controls too. Can anybody give me a source code on how I can link these two tables programmatically?

---

Are you wanting to do it programatically or using the Data Control?

---

Either one, which ever is less complicated I guess.

TnTBass

http://www.1337geek.com/code/vb6/database/ADODB/

This code sample has only one table, but you should be able to link the two, using proper select statements (joins).

Then just use the rs.insert, rs.delete, etc to work for both tables.