Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2015
    Posts
    23

    Unanswered: Union query and multi valued fields

    Please i have two tables with multi valued fields. i want to join the two tables using union query but it wouldn't work because of the multi valued fields. i need a solution please. thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    i need a solution please
    OK my preferred solution..
    don't use multivalued 'fields'

    design the DB properly
    use normalisation
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    The Jaded One expressed my sentiments as well!

    What the Boys of Redmond did, when adding this ill-advised type of Field, was to include a hidden Table that actually holds the data for these multi-valued Fields, in a one-to-many relationship. The solution I've always seen, from developers far more experienced than myself, for your kind of problem, is to dump the MVFs, and add an additional Table, that isn't hidden, to hold the data!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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