Check multiple beans if exists

[Crusifficadus CR]

Dear redbeaners,

I have some problem while trying to find an existed person in multiple beans. I'm looking for suggestion from you guys.

Here's the example :

apartment :

id

room

floor

pic (person in charge for general stuff)

hotel :

id

room

floor

pic

pqlty (pic for standards of quality)

What i'm trying to check is, if the John Doe exists in apartment_pic, he can't be a pic and/or pqlty in hotel bean and vise versa. what is the best option for this purpose? should i use many-to-many or just create some tags for those beans? Thanks.

[gabor]

Why not invert the relationship:

person:
picplace_id = place.id

place
id
accomodation_type
room
floor
pqlty

cheers
Gabor