filter Field

  • Thread starter Stephane A. Aubertin
  • Start date
S

Stephane A. Aubertin

Hello,

I'm a new ACCESS user and I already hit a problem not explain in the ACCESS help.
I have a table named t_building with the key field BuildingCode.
BuildingCode
BU1
BU2
....

I have a other table named t_Story with keys fields BuildingCode and StoryNum.
BuildingCode StoryNum
BU1 01
BU1 02
BU2 01
BU2 02
BU2 03
BU2 04
....

And finaly table t_Room with fields BuildingCode, StoryNum and RoomNu
BuildingCode StoryNum RoomNu
BU1 01 BU1-01.100
BU1 01 BU1-01.101
BU1 02 BU1-02.100

How can i have a list of StoryNum value just for the BuildingCode. If I enter BuildingCode "BU1" in the next field StoryNum I should have a list with only "01" and "02".
I tried somme Querys but it alwals give me the hole story liste "01", "02", "03" and "04".

I hope that my question is clear

Thanks Stephane
 
Top