What sort of Query ?

[PhilipEwen]

Hi i have a dataset of Counrties, Resorts in country, Hotels in resort.
I have multiple entries for hotels in resort as each hotels' prices on a particular day are stored ( hotelname, date, price )
i.e.
Alicante hotel 01/01/01 £99
Alicante hotel 02/01/01 £89
Alicante hotel 03/01/01 £59

When i therefore select a country and the a resort it brings up the hotles within that resort.

My problem is that it brings up Alicante Hotel three times. How do i get it to show only the once?
Is it a query or the realationships to tables ? ( one to many )

Thanks

 

[SteveA]

Hi again.

I would probably break the Hotel table into two separate tables. One table holding the hotel and which resort it relates to (Hotel), and the second table holding the rate, date and which hotel the rate relates to (Rates).

I hope this helps

SteveA

 

[PhilipEwen]

unfortunately i think you are right...
damn !
Thanks again