CaseBO {pkCaseId, CaseDesc, fkClientId, fkContactId}

ClientBO {pkClientId, ClientName}

ContactBO {pkContactId, ContactName, fkClientId

I've created a form, called Case Form

On my Case form I have an instance of all three BO's, successfully related, and as I navigate the CaseBO I can display any number of fields from the related Client and Contact BO's. All's well so far...

Now I create a second form, Client Form.

I drop an instance of the ClientBO and ContactBO and begin to setup the relationships...here's where I run into an issue. In order to setup a relationship between these instances of ClientBO and ContactBO on the new form (clientBO1.pkClientId<->contactBO1.fkClientId), I have to break the relationships I'd set up on the first form (caseBO1.fkClientId<->clientBO1.pkClientId & caseBO1.fkContactId<->contactBO1.pkContactId)

It seems that a BO will only allow one association? I'm sure I'm missing something here, I don't think that's correct because, if it is, I'd have to create a new BO for each kind of association...duplicating a lot of code in the process.

TIA,

Rob