Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Ventura, California, USA
    Thanked 0 Times in 0 Posts

    Pop-up form from search (2002)

    I am sure this is a simple issue I am just not having luck getting the answer. I have a table that includes all of our companies storage boxes. Each box is identified with its own storage number. Problem is we have Account information in several boxes in storage. What I want is to be able to enter into my DB the Account number and a pop-up form list the boxes they are in. If anyone could point in the right direction I would be very appreciative.


  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: Pop-up form from search (2002)

    Essentially you have a many-to-many relationship between Accounts and boxes; that is one account may have info in many boxes, and 1 box may have info from many accounts. What you need is what we call a "resolver" table. This table merely has to contain 2 fields AccountID and BoxID. A subform on your Account form will then show which boxes the account is in. A subform on your Box form will show what Accounts are in the box.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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