booking system

hi all,

recently i developed booking system.

i had encountered a prob my customer have 3 resorts. so after tourist confirmed stay at they resort they will use my booking system to assign to particulars resort.

1) how do i know the resort have vacant room or not

2) i wan make a combobox down-arrow button when click it another windows tat have grid box to select. and i wan tis data will be differentiate by resort code.

i rili no idea at this part.

Thanks for advice.

Visual FoxPro2

>1) how do i know the resort have vacant room or not

You would have to create a query for this. It depends on your data file structure design. Maybe you have a table with rooms per resort and dates of occupancy so you would have to create a query that checks for unoccupied rooms between the dates the tourists want.

It is hard to say without knowing your data structures.

2) i wan make a combobox down-arrow button when click it another windows tat have grid box to select. and i wan tis data will be differentiate by resort code.

Add code to the Click() or InteractiveChange() methods of the combobox to call a method to requery a grid's control source to show the available data by resort.

Don't do the query directly in those methods, but call a common method of the form so it can be called from different places and it is more reusable.

thanks for your reply.

now i design and planning the database.

1) ask customer do have exisiting resort management program or not ... maybe can use they data to read-in into my program to updated room vacant.

2) i have a resort management system but ned to charge my customer and ned train them how to use.

tings come to worse all data will be consildated by using email instead of FTP server.

thanks in advance.