Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78

    Question Unanswered: dynaset recordset

    Hello All. I have a realy simple question! I want to create a recordset that can be updated. See attached pic. I want to add possible many flights and many passengers. When i try to do this in the qbe grid it wont let me update the recordset. One Booking has many flights and many passengers?

    Help please
    Attached Thumbnails Attached Thumbnails tables.jpg  
    the light is on, someone is home, but they dont know they are. HELLO!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Dap,

    Ok. Recordsets can be updateable ... They must be on ONLY ONE TABLE THO. If you have a recordset that spans 2 or more tables it cannot be updateable. THat being said, you will have to have a recordset for each table to be added to ...

  3. #3
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78
    Originally posted by M Owen
    Dap,

    Ok. Recordsets can be updateable ... They must be on ONLY ONE TABLE THO. If you have a recordset that spans 2 or more tables it cannot be updateable. THat being said, you will have to have a recordset for each table to be added to ...
    Cool no problem. I am doing this in code so is it best to do the old:

    set db = currentdb
    set rs = db.openrecordset(sqlstatement)

    with rs
    .add
    !fieldname
    .update
    end with

    whilst im here.... can i use the currentdb over a split db over a network? I am planning to run my application on two pc's one front end on each pc linking into a single back end database?
    the light is on, someone is home, but they dont know they are. HELLO!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •