Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    74

    Unhappy Unanswered: retrieve 2 similar records in a form

    hi,

    i have a form where there is a combo box. when the user select the combo box, it will retrieve the records under a particular account no.

    example,
    i have 2 customers under an account no, when i retrieve records of the customer1 thru the combo boxes, how can i display both the customer name onto my form in 2 seperate fields???

    it sounds complicate so i have attached a db for your reference.

    pls advice
    nono
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Just curious...
    Is it possible that 1 contact could have 3 or more customers?
    Inspiration Through Fermentation

  3. #3
    Join Date
    Nov 2003
    Posts
    74
    yes,

    any better ideas???

    using tabular form???

    but i need to retieve the value of the fields , in tabular how can i do that as i cannot name my textfield (properties).

    actually this form i use it for merging of records therefore if this account has two customer records then i will have to create a merge where these 2 records value will be pass in.

    so how can i do that to retrieve the value so that i can pass in???

    pls advice
    nono
    Last edited by damnnono_86; 11-23-03 at 21:18.

  4. #4
    Join Date
    Nov 2003
    Posts
    74
    the new attachment!!!
    Attached Files Attached Files

  5. #5
    Join Date
    Nov 2003
    Posts
    74

    Unhappy

    can somebody help???

    nono

Posting Permissions

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