I've set up a database for my vacation rental. It's now working very well, but I'm trying to put the icing on the cake.
I would like to add a button that will take me to the current guest.
I've tried scripting a loop that will go to today's date (based on arrival date) then, if not found, try yesterday, then the day before etc. etc. until if finds the last arrival date ... and hence the guest currently in residence (or last guest, if noone is currently staying).
I'm still very new to this and I'm fumbling around in the script workspace. Could someone suggest how I could do this?
Thanks, in anticipation.