listing of a records according to entered criteria
Please help! I have a database of maintenance buildings, with a record of all reports about problems that need to be solved. As we have crossed the figure of 6000 records it would be good to have a history of all the records sorted in some kind of a list of a records according to entered criteria and shown immediately. For example, if someone reports a problem, we write the address down and as we do that it would be great to immediately see a list of all reports from the specified street. Furthermore, when entering the house number of the building the report came from, to show us just the reports from that address. If someone has a solution, I would be grateful.