In the missing person table, each record has the data of the agency that entered the missing person, their telephone number and agency name (that is part of each record) ORI is their NCIC assigned identifier Each record has a total of 132 fields in them Since the datbase contains certian personal information, I am not able to give you full details of the contents of the database since the record also contain some personal information of the person that is missing.... The live database information is located on a secure part of the website and only certain persons can obtain the record that they query on Ken --- In php-objects@xxxxxxxxxxxxxxx, Pete <cgrp@...> wrote: > > In message <fkqubs+cgqk@...>, Ken <ken.poyser@...> > writes > >In the result display window > > > >It list the > > > >ORI Phone Numuber Ageny Name > >OK0990000 405 -555-0000 PD SOMEWHERE > > > > > >what I would like to have it list the number of records that > >OK0990000 has entered whereas it would display > > > >ORI # of Rec Phone Number Agency Name > >OK0990000 45 405 555-0000 PD SOMEWHERE > > What's causing confusion, is that your database does not appear to be > designed properly. > > There should be 2 tables: > officetable: ORI (assume that this is the office ID), PhoneNumber, > AgencyName > missingpersontable: ORI (the office where the person is registered), > personname, whatever else... > > Do you have a record for every single missing person in a single table, > with the office name and phone number in each record? > > Still not sure what ORI is - is it something that is obvious to an > american? > > -- > Pete Clark > > Sunny Andalucia > http://hotcosta.com/Andalucia.Spain >
