Hi,
For creating s scheduling appointment database, you can have 2 or 3 tables,
1 table would store the contact information like name, address, phone etc,
another tabel schedule that would contain contat name, date time, puropse of
appointment, more like a description, probably you could use another table
that has details about if hte appointment would be rescheduled as in post
poned or preponed etc. You can link the schedule table and the contact table
with the contact id. In case you using the 3rd table you can link that and
the schedule table usign the appointment id.
I hope this helped you.
need anything let me know.
Anand
