March 27, 200322 yr 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.
March 28, 200322 yr Case(not IsEmpty(::your relationship:CompanyLastNameIDCalc, "Yes, "No"). But not sure if your relation is already "related" to Wednesday....
March 28, 200322 yr Author I think I figured out a solution using value lists and pattern count. Thanks for responding.
Create an account or sign in to comment