There is a feature of Quick Base called a snapshot field. Read about it
here That will allow you to freeze the value of the House Manager at the time the Bed is assigned. That will be that you will have two values for the house manager, one would be called the current house manager and the other would be called house manager at time of the bed assignment.
As for seeing the history of all the House Managers over the course of the dates of the bed assignment, There are a variety of approaches to that.
It appears that in your design you have a table where one house has many house managers and therefore you have a history of the house managers overtime. Presumably those records have dates on them as to when they started and ended up being the active house manager.
So one approach to showing a history of all the house managers between the dates of the bed assignment would be to create a button which would run a report. The report would have <ask the user> questions For the start date and the end date and of course the related house. So the user would click a button and it would run the report and answer it's own questions and provide a result on a button to click.
If you did want to try that approach then create that report with those three questions and then post back and I can help you with the URL formula which will run that report and answer the questions.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
