Hello. I need a little help. Could you pls explain me how I can resolve this case:
I have 3 tables - User, Equipment and Appointment. Users can use a several Equipments. Users can register a several Appointments. I want to check when user registers to the Appointment this Equipment is free or not.
I created 3 relationship between User and Equipment, Appointment and User, Appointment and Equipment. And I don’t know how to check this tables between together
I want to show for the login user the List where will be only free appointments with free equipments for this user.