Automaticaly recalling relevant data

[Rax]

New at this so please bear with me.

I am designing a database for work and need to recall data into one layout from another.

e.g.

In Quotes Iayout I have:

Room A, 4.5m length, 5.0m width, 3.0m height

Room B, 7.2m length, 5.0m width, 3.6m height

etc, etc.

In Accounts layout I wish to recall all the relevant data just by typing in say Room A and having all the dimensions displayed automaticaly.

Any guidance would be greatly appreciated

Thanks

Rax

[T-Square]

Assuming:

* a structure with a table for Rooms and one for Accounts,

* a RoomID field in each table,

* a second Table occurence of Rooms on the Relationship graph (called AccountRoom)

* a relationship between AccountRoom::RoomID = Accounts::RoomID

* a value list RoomList based on the Rooms table showing RoomID and RoomName

Create a Dropdown control on your Accounts layout for the Accounts::RoomID field and set it to use the RoomName valuelist. Add AccountRoom::Length, AccountRoom::Width, AccountRoom::Height

When you select a room from the list, all its dimensions will display.

HTH,

David