For Upstairs/Downstairs:
In UR pro
http://www.kinook.com/UltraRecall/Ma...odatabases.htm
"Ultra Recall allows multiple users to open the same Info Database (located on a network share or shared folder) simultaneously for editing." Record locking may perhaps get you (or save you) with your usage scenario.