Advice - best way to design app for hotel and business status reporting

[tcanelli]

We want to create an app for local businesses and hotels to report their status after a disaster.

I initially started with just one table that had business contact info and status info, with status col being a dependent drop down depending on industry type.

Then I thought it may be better to just have business contact info in one table and the status updates in another in case businesses update more than once. Dependent dropdown didn’t work when I did this.

I am not sure how we would have a business “log in” to update just their records, so it is better just to have all the information in one table and sort the table view with most recent report at the top in case a business reports more than once?

Would like to know if anyone has already done something like this and what works best.

Thanks