Validation Rule

[something]

Hiya,



I have two fields, Ticket_Type and Prices, in my Ticket_Type it's a combo box with the list Non-Standard, Standard and Premium. In my Prices field, it has a combo box £30, £50, £80.

Is there a validation rule that can link those two combo boxes together in the database table:
e.g
Ticket_Type Prices
Non-Standard £30
Standard £50
Premium £80

Thanks

[RuralGuy]

I hope you realize you are asking for an Access rule that violates database normalization rules. If they are tied together then why have two fields? Why can't they just be one?