ruthcarlton Posted March 27, 2003 Share Posted March 27, 2003 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. Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted March 28, 2003 Share Posted March 28, 2003 Case(not IsEmpty(::your relationship:CompanyLastNameIDCalc, "Yes, "No"). But not sure if your relation is already "related" to Wednesday.... Link to comment Share on other sites More sharing options...
ruthcarlton Posted March 28, 2003 Author Share Posted March 28, 2003 I think I figured out a solution using value lists and pattern count. Thanks for responding. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7865 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now