Search results

Business reports would be done yearly to see how the business is doing. In the table of business reports, records are added chronologically so for every business, there would be different business reports but at different dates. My plan at the moment is to have the business list table which...

Date of each business report, type of report, reason for reporting, follow-ups, comments It would be like a periodic thing.

Having a form that will have a business list subform where I would be able to pick individual businesses and have the ability to open a form for each business where I would be able to input a 'business report'

Sorry, it seems as if they have been just inputting it manually into the table. I think the best way to input such reports is in the business list, having the option to open up a report form which will then have all the basic business information always saved and be consistent.

Editing the original sample I made, some of the reports made originally were never made consistently, this is one reason I would like them to have the same ID so it can be easier to access all the reports from a specific business even if the data itself was not entered correctly. Reports List...

I believe this could also be done by having the query find business reports with similar names and addresses to then assign it automatically to the corresponding business ID?

Sorry, that wouldn't be possible. I understand that it would not store the actual business name but that is how it was already, I believe it can just be ignored even if it is useless?

I believe these tables might make it clear, so in the reports list, there are multiple reports per business and I want the ID field to automatically match the ID field from the business list using the business name, street #, and street name. However, all three of these fields are never inputted...

Hello, I have two tables, one with the Businesses and its individual ID for each business along with some information for each such as addresses. In the other table, I have reports for each business but no ID, I want to link each report so it updates with the ID of the first table using...