History of all the records sorted in some kind of a table according to entered

[Tonko1]

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 table 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.

[efen]

How is your file structured? Is all the information in one table of 6000 records or is there a table of buildings and a table of 6000 reports? Or...?

It would probably be easier to answer your question if you post a copy of the file with a few dummy records...

...and welcome to the forum

Edited February 19, 2010 by Guest