Results 1 to 2 of 2

Thread: several Recordsource Managment

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jun 2000
    Posts
    18
    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

  2. #2
    Lively Member
    Join Date
    Oct 2000
    Location
    Leicestershire; ENGLAND
    Posts
    71
    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
  •  



Click Here to Expand Forum to Full Width