I’m trying to create a portal for Dental Clinics and Labs to communicate. I want the Dental Clinics to be able to create an account with several users (employees ) who then link to a Dental Lab and send cases to them. Dental Labs should also be able to create accounts for themselves and link to Dental Clinics if they wish.
My data base images are attached. I want to be able to display the data as shown in the dashboard image, but I’m having trouble understanding how to add or create a new case when there are more than one data type in my input fields in the new case pop up. I probably have it all wrong but I will like to understand how I’m supposed to do it. Any help would be appreciated.