Linking columns in in 1 table

[jhong]

I have a table that I'm trying to link 2 columns. One column is called Levels & the other one is called Room. Both columns are in the same table. The levels column has a drop down feature. I'm trying to link the columns together so when I choose a value in the levels column in the field, it will automatically change to the corresponding value in the room column. Can anyone help me out?

 

[pr2-eugin]

If you are using a Form to update records then you can use the 'After Update' property of the 'Levels' (your dropdown box name). as such.

Private Sub Levels_AfterUpdate()
Room.Value=Levels.Value
End Sub

not sure if this is what you are looking for.

 

[jhong]

Is this in SQL? or the design view in Access?

 

[gemma-the-husky]

there is something wrong here

how can you have two columns (fields) in a single table, so that changing one affects another column?

if this is really case, then your table design needs some attention

 

[rodmc]

indeed, there is something wrong, even though its wrong relational wise it sounds wrong logic wise also, then again its Friday, and my grey matter gives up around 12 on Fridays