Results 1 to 2 of 2

Thread: 1:N relations

  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Unanswered: 1:N relations

    I could not format this correctly, so I've deleted it. Sorry.

    Dave44000
    Last edited by Dave44000; 12-03-13 at 16:41.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    No problem, I can handle fixing the formatting issues for you!
    Quote Originally Posted by Dave44000 View Post
    As a novice I defined my lookup tables in the tables. I moved them to combo boxes. Now, I have to put four phone numbers of different types in a single row, so I can mail merge it to a report in MS Word. The phone numbers are in a 1:N relationship with a customer. I can filter on the type ID. Sometimes I have more than one phone number of a particular type. I get something like the following:

    Code:
     OFFICE FAX ... ...
    customer A ###-####
    customer A ###-####
    customer A ###-####
    customer A ###-####
    customer A ###-####
    I was then going to move the numbers up to the first row using vba, but is this the best way to get a single row

    Code:
    customer A ###-#### ###-#### ###-#### ###-####
    But, is this the easiest way to get this done? I have a lot of these kinds of relationships.
    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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