Combo box and text box help.

[Rosinino]

Hi,

I have a combo box on a form with three values, when I select one of the values I want a text box to show a corresponding value.

The combo box has three values for different types of memberships; under18, over60, and standard, these have different prices. So what I want is for when one of the values is selected the text box will show the price.

Any help on how to do this? The database is below.

 

[RuralGuy]

Here's a method that should work for you. It obeys normalization rules. You were trying to put the price in two tables.

 

[Rosinino]

Excellent, works a treat. Thanks

 

[RuralGuy]

Glad I could help. Queries are very powerful!