You will have to add a Mapping Class, like in a relational database:
Class UserService {
Relationship USER As USERS (cardinality=one,required)
Relationship SREVICE As SERVICES (cardinality=one,required)
}and the appropiate many-Relationships in USERS and SERVICES
Then, for each relationship between a USER and a SERVICE, you gonna create a UserService Object.
you can query this model with:
SELECT USER->USERNAME,USER->LOCATION FROM UserService WHERE SERVICE->SERVCIENAME='...'
no ugly joins required
hope this helps
Georg
Robert Willis wrote:
I trying to create classes to map relationships between users and services and can appreciate that Cache does not currently support many-to-many relationships.
I have USERID, USERNAME, LOCATION in my USERS class
and
SERVICENAME in my SERVICES class
How best should I set up the relationships and how can I get MSAccess to display the services / users.
Once I get this working I will have to do the same for SLAs, HARDWARE and DATA so the database works lke a CMDB
Are they any examples of this (I coundn't see much in Documatic and Cinema didn't seem to yield any hints) that I could follow?
