This topic is locked

Confused novice seeks help with relationship

9/18/2007 2:59:57 PM
PHPRunner General questions
D
depoteet author

If someone could provide help for a hopelessly confused user, I'd appreciate it.
Thanks,
Darrell
A directory of members and the services they provide.

Each member will provide at least one service but may provide many.

Primary function is to allow a search of a service and return a list of members providing that service.
I cannot figure out the proper setup of Master/Detail relationship for these three tables in PHPRunner.
3 Tables
Members
member_id

member_name
Services
service_id

service_name
MemberServices
member_id

service_id

Sergey Kornilov admin 9/18/2007

Darrel,
if search function is all what you need don't use Master-Details relationships.
Run a search against MemberServices table to get a list of members who provide a service.
The answer actually depends on what functionality you need besides the search.