Click to See Complete Forum and Search --> : Updating Tables


HanneSThEGreaT
September 27th, 2001, 06:35 PM
Hello, I've got an application that makes use of 2 Database tables and a seperate form for each. The problem is that:
I want to update Table 1 out of form2(which is connected to table 2) and vice versa. What is the easiest way to do this¿
Thanx

F. T. W.

Cakkie
September 28th, 2001, 01:22 AM
If you are using bound controls, it is simple. Just bound the controls to the other datasource. If you are using a datacontrol, you need to set the datacontrols datasource property to the other table. If you don't use a datacontrol, you must change this property for every control on the form.

One thing you need to keep in mind is that this will only be possible if both tables have the same fields (or at least all the fields used on the forms)

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook