Calculation Confusion

[ruthcarlton]

I am trying to create a hotel assignment system. I have a db of people with hotel request criteria and a db of rooms with potentially matching criteria. Every room has 5 days in the record and every person has 1-5 days requested for room assignment. If the people's request match the hotel room criteria they appear in a drop down menu for that day. That all works fine.

What I want to do is have their names eliminated from the menu when they have been assigned a room.

I tried...

If(HotelRooms::Wed = CompanyLastNameIDCalc, "Yes", "No")

Where the relationship "HotelRooms" is based on the match I described above, but the Calculation is too broad and only finds one person where there will be many who meet the criteria.

I need a calculation that will tell me If a person has been assigned to a hotel room on Wed, based on data in a hotel room record.

[Ugo DI LUCA]

Case(not IsEmpty(::your relationship:CompanyLastNameIDCalc, "Yes, "No").

But not sure if your relation is already "related" to Wednesday....

[ruthcarlton]

I think I figured out a solution using value lists and pattern count. Thanks for responding.