Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi again

    I have to use data from an ODBC table, append to another table and fill in the blanks manually using a form.
    This is not a problem.
    When I run the query to pull the ODBC data again, the table is overwritten and the manual data is lost .

    So Ideally, can I save the current record ( on the form ) into another table for safe keeping?

    How could I do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could store the extra information in a second table with a one-to-one relationship with the table you get from the ODBC query.
    You'd need a field from the main table that will be preserved when it is overwritten as link field.

    For data entry in the second table, you could use a subform of the form bound to the main table. As soon as you start entering data in the subform, the link field would be filled in automatically.
    When the main table is overwritten, the second table will not be affected, and as long as the link field remains the same, the data in the two tables will be in sync.

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hans

    You don't have a very quick example do you so I can study it?
    I think my whole database is incorrect, perhaps looking at aneample would help me along.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Sorry for the late reply, I was away for the evening.

    Here's a little example. There are two tables: tblODBCData (corresponding to the table that you import) and tblExtraData (to store the additional information).
    The form based on tblODBCData has a subform based on tblExtraData, so you can enter data in tblExtraData while looking at the existing information in tblODBCData. The additional information is stored in tblExtraData, not in tblODBCData, so even if tblODBCData is overwritten, the additional info is preserved.
    Attached Files Attached Files

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes I see now Hans

    I kind of had the same set up.
    Thanks once again for giving me a good start.

Posting Permissions

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