-
Nov 1st, 2000, 07:10 PM
#1
Thread Starter
Junior Member
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
-
Nov 2nd, 2000, 11:50 AM
#2
Lively Member
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 ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|