Relationships

[brucey54]

Hi folks,

Please could someone help me with the following problem?

Why is it when I click on the TblCarerdetails and try to open a record with the plus sign I am present with the following error message

“Enter Parameter value CarerID”

The frmCarerRota seems to be working ok, the relationships seem to be ok i.e



TblCarers can have many rotas i.e. a different TblRota each week (1 - M)

TblClients can have different TblRotas each week (1 - M)

Any help or feedback would be much appreciated

I am hoping to understand why the tables are not linking correctly, if I click on the TblCarer plus sign.

I should see the Rota details and a plus sign. If click on the plus sign, I should see the clients details.

Therefore I am assuming that my relationships are not correct, I think I need to add an association table, but where and what fields do I need to add/create.

Tom


Happy New Year

[June7]

Guess I haven't worked much with many-to-many relationships. I don't allow interaction with tables so never gave this much thought but am thinking that is reason for this. TblRota is a 'junction' table that associates carers with clients. When I click the + on TblCarerDetails it prompts for CarerIDFK, I ignore it and then the subtable opens for TblClientDetails. Interesting. Personally, as long as the queries, forms, reports work properly, wouldn't worry about this. Just don't work directly with the tables.

You might want to change the jointype of the relationships from INNER to "Include ALL records from 'TblRota' ..."