<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Shaun" <[EMAIL PROTECTED]> wrote on 01/23/2006 11:51:32 AM:
>
>> Hi,
>>
>> We have a dataset of uk postcodes and their relevant X-Coordinates and
>> Y-Coordinates, a table of properties (houses), a table of users and a
> table
>> of o
It might be more productive to add a foreign key to the
Offices and Properties tables that points to the
Primary key ID of the respective PostCode in the Postcodes table.
Combined with the other suggestions, this would give you a
key from the Offices and Properties tables directly into the
Po
We use the inradius function as described here:
http://www.phparch.com/discuss/index.php?t=msg&th=878
It's not the fast way I'm sure but seems to be pretty reliable.
Instead of the zipdata table you would point it at the Postcodes table
and the Properties table. You'll also need to add an X,Y (
"Shaun" <[EMAIL PROTECTED]> wrote on 01/23/2006 11:51:32 AM:
> Hi,
>
> We have a dataset of uk postcodes and their relevant X-Coordinates and
> Y-Coordinates, a table of properties (houses), a table of users and a
table
> of offices - users work in an office - table structures below.
>
> Is i
