Hi I work for a non-profit and we're trying to implement a database to help people search for services that are appropriate for them.
Since every service can have a range of categories within categories (ie accommodation, eligibility, agegroupings) and every category could be used more than once, we're thinking that junction tables are the best way to go?
How would I setup PHPrunner to handle the junction tables with the master-child settings? Or do I need to manually write SQL code?
sample of the structure
ie tblServices - tblJunctionAccomm - tblAccomm
tblServices -tblJunctionEligibility - tblEligibility
Thanks for your help.