It is posible to control several recordsources ( for example: diferent tables within an Access database which hava an id number as a relationship) with just one data control?? Please explain...
Thanks
Printable View
It is posible to control several recordsources ( for example: diferent tables within an Access database which hava an id number as a relationship) with just one data control?? Please explain...
Thanks
Assuming that your tables are linked as you say, then yes you can. Set the recourdSource property of your data control to somethin like:
SELECT * FROM CUSTS, INVS WHERE CUSTS.ID=INVS.CUSTID
This will then retrieve all related data from the two tables. This may not work however if you wish to update the data, it depends on the database ...