several Recordsource Managment

[ALFA117]

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

[Orpheus]

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 ...