Hi Ove,
One possible solution: A form displaying tblHouse records, and
containing a subform showing tblRoom records. If you set it up
properly, Access will handle the filtering of the subform automatically.
Something else that might be of use: A pair of combo boxes, where the
user selects a house in the first one, and then the second one shows
only those rooms that belong to the chosen house. There's a
description of how to do this in the MS Knowledge base ("How to Create
Synchronized Combo Boxes"):
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576
Good luck,
Peter Hoogenboom
--- In [email protected], "Ove Billing" <[EMAIL PROTECTED]> wrote:
>
> I am not very skilled at Access but try anyway to help a small local
> museum to erect a base with their objects.
> One problem to handle (with simplified examples): I think of having a
> tblHouse with 4 records (H1, H2, H3 and H4) and a tblRoom with many
> rooms (R1, R2 ...), some in H1, others in H2 etc. How do I construct a
> form where only rooms in H1 are visible or choosable when first
> choosing H1 etc. ? Is this possible? Other ways?
>
