The client want to be able to create a database labeled "Current Inventory" with the following fields:
Arrival Date, Number nights (1-7),Property Name, Location, # bedrooms, Unit Description, Cost (this field needs to be a general number, not necessarily $), Owner of Record, Name of Guest.
He then want to be able to somehow, when the Name of the Guest is entered, this particular information will then be transferred from the "Current Inventory" to another database that is called "Booked Inventory"
We would also like to be able to look up by name once a guest has been moved to the "booked inventory" to find the record.
Also, we would like to be able to look at the "Current Inventory" page at a glance. I do not need a search field? Just maybe a spreadsheet that we could go into and add inventory to, by date. I have a spreadsheet I can email to show a sample of what we use now.
Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.