Cindy,

I'm designing a small sports booking system for a friend of mine. On one of the facilities, I have a grid, in one column I have all the times that facility can be used. Beside that, I have the name of the person using that facility at that time.

You see, this grid is populated using an SQL select statement, and is therefore temporary. When I click on a date, and then time, all of the information is added to the table, permanently.

This is why the table needs a (date + time) as the primary key. Now the user has told me that often a booking is made and then soon before use, is cancelled, and another person then makes a booking for that facility at that time.

For this reason, I must be able to permanently remove the record immediately. I was thinking if I use COPY STUCTURE TO "tempTable", then use information from tempTable. Then if I want to delete, I can do it with no index violation errors? At the end of all, I can copy the information back to the permanent table. This however I believe, is what the PACK command does!!

I'm sorry if this problem is a bit soft, but I have only recently started using VFP and this is my first project.

From reading this information you have any suggestions, they are all welcomed.

Thanks again,
Mick