Hi
I have a MSFlexgrid inside my VB6 form.The backend is Access 2003.This flexgrid contains 144 rows and 1 column Room1:The Flexgrid looks like:
Intervals Room1
06.00 to 06.10
06.10 to 06.20
06.20 to 06.30
06.30 to 06.40
...and so on covering the 24 hours

If a client wants to book the Room1 between 06.00 to 06.30 then I add a record to a table "Book" in which I enter all the information about the client and I add the Intervals' ID to a table "Intervallist" that has 3 fields:
ID-Autonumber
RId-The record ID of the record just added(containing the informations about the client)
IntervalID-The intervals ID(e.g if the user wants to book the room between 06.00 to 06.30 then suppose that 06.00 to 06.10 has an ID of 7,06.10 to 06.20 has an ID of 8 and 06.20 to 06.30 has an ID of 9 then if Rid=24
then I should add to intervallist
Autonumber 24 7
Autonumber 24 8
Autonumber 24 9

Suppose that the user changes his mind and He want to book the room between 06.00 to 06.50 what's the best way to edit the intervallist table?
My method was to delete all the records in Intervallist that has a RID=24 and then reenter the new intervals' ID with their corresponding RID,but this method causes to me a lot of Problems.

Can anyone help me because it's extremely urgent
thanks in advance