Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Charleston, SC
    Posts
    11

    Question Unanswered: Two sets of parts - one Request for Quote????

    I am trying to merge two sets of part numbers (and they DO have to be maintained separately) to be used on one RFQ form. My trouble is that the user needs to be able to modify the part information (either set) AND the RFQ number is stored on the part number table, and if I use a Union Query, the query isn't updatable.

    Is there an alternative?

    Thanks,

    texassprite

  2. #2
    Join Date
    Jan 2004
    Location
    Bedford, UK
    Posts
    5
    Try setting the query's property 'Recordset Type' to 'Dynaset (inconsistent updates)'.

    David

  3. #3
    Join Date
    Jan 2004
    Location
    Charleston, SC
    Posts
    11
    Originally posted by dcb
    Try setting the query's property 'Recordset Type' to 'Dynaset (inconsistent updates)'.
    I'm using a SQL union query, and I'm not sure how (or if I can) do that here...

Posting Permissions

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