Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using information from a subform (2000)

    I have a subform that is populated by a query. The query takes information from two different tables. The query joins the tables by a common field, (IDField). The first table is a list of registered individuals attending a camp; all records in this table have a unique number in the IDField. The second table is a table of beds available and the IDField is blank until an attendee is assigned a bed. Then their ID number is entered into the second table

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using information from a subform (2000)

    If only one bed should be assigned to a happy camper, you should not put the camper ID into the beds table, but the bed ID into the camper table. The user can select the bed from a combo box whose row source is the beds table.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using information from a subform (2000)

    It was originally setup this way because the attendees table was going to come from a second backdoor that we would not be able to write to, but it is looking more and more as if that will not be possible. Would the subform then be populated by the attendee table in stead of the query? The user is able to pick a bed from a set of four cascading combo boxes connected to the bed table.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using information from a subform (2000)

    Yes, the (sub)form would have the attendees table as record source.

Posting Permissions

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