Hi i seem to be having a problem with my database. I have a customers, appointment and appointment details table and forms. Whenever i enter a customer and add appointment details, close. Reopen it and click the appoitment button to bring the appointment form up and it will create a new record. How do i bind an appointment to a customer, so when u open an appointment which is linked via customer id to load up the same details and not create a new record?
So only that ONE customer can make ONE appointment. they cant make more than one? hmmm come to think of it isnt that just a relationship thing?
So only that ONE customer can make ONE appointment. they cant make more than one? hmmm come to think of it isnt that just a relationship thing?