hi, i am writing a web site for insurance agent. The user have to fill form , post it and wait for call from the insurance agent. The site will offer different kinds of insurance i will refer only for car insurance
Since the values in tbl_drivers and tbl_claims came form Dropdowns the user have limited number of possibilities and those tables will have fixed number of raws.
The problem is when i want to insert new appeal. I have to check if the values the user enter exist in tbl_drivers and tbl_claims, then, if they exist to take the PK of those tables and insert them to tbl_car, if they do not exist i have to insert them and then to take the PK of those tables and insert them to tbl_car.
Eventually the table tbl_drivers and tbl_claims will have all the combinations that the dropdowns are offer, so the checking will be irrelevant.
Previous Topic
