Sorry to bother you but I have another problem, i think it will be a big problem if i dont solve it before giving the database to the users.

the problem is, when i add a new record, in the customer part, it just adds to table, right after the last record, but in the questionnaire part, it adds a blank record with a CIS number 0, then the record I just entered. this is not good if I want to do some queries cos it will have some wrong data.

help appreciated