I'm using L5 and I'm trying to figure out how to do the relationships for the following tables any help would be appreciated.
clinics locations zipcodes
clinics are over a list of zip codes
locations are attached to some of the zip codes assigned to the clinic but not all.
clinic 1 has 10 zip codes assigned to it. clinic 1 has 3 locations 1 locations are attached to 3 of the zipcodes attached to the clinic zip codes 3 out of 10 assigned zip codes.
Thanks in advance for your help.