I'm developing a script that keeps a simple log of data in a database to be recalled at random. The log contains a unique ID, an inquiry ID, date, time, operator name, operator number, officer name, badge number, name of person inquired on, date of birth, federal ID number, state ID number and up to four dispositions......
The purpose of this project is to migrate from a hand written form that contains all of this data to an online form that's accessible to anyone with the proper credentials. The unique ID and inquiry ID are automatically assigned. When you make an entry into the system, it asks how many inquiry numbers you need and then inserts separate entries into the database for as many inquiries as you said you needed.
What I need to happen somewhere along the way is to group duplicated names, dates of birth that were logged at the same time so that instead of showing two different rows for two different inquiries...it shows one row that has all that person's data plus lists each inquiry number in one box.
Is this feasible?
