Soldato
- Joined
- 22 Nov 2007
- Posts
- 4,176
Hi All
I’ve beeb making a doctor/patient appointment booking app. I have an appointment table with patient/doctor id as foreign keys, i have an admin screen where appointment details can be entered (date, time, doctor name).
I will have a drop down to display the doctor names populated with a select statement. I can’t figure out how this will work if there are two doctors with the same name when doing the sql insert( insert doctor id into appointments where doctor name = doctor id)
this is a personal project as i’ve recently finished a udemy python course fyi
I’ve beeb making a doctor/patient appointment booking app. I have an appointment table with patient/doctor id as foreign keys, i have an admin screen where appointment details can be entered (date, time, doctor name).
I will have a drop down to display the doctor names populated with a select statement. I can’t figure out how this will work if there are two doctors with the same name when doing the sql insert( insert doctor id into appointments where doctor name = doctor id)
this is a personal project as i’ve recently finished a udemy python course fyi