Thanks @JTRTech I like your solution, can it work for a hotel with about 100 rooms?
hope the below is the link