>I have a client table that has a field postalcode(field-postalcode)
>I have a town table that lists all towns and all possible postal codes for these towns(fields - pcode, town)
>I have a dropdown list that fills from a town.dbf
>
>If user selects Toronto from the list - I want all clients to be displayed where the postal codes match based on the town.
>
> what's the best way to handle this, I'm doing it on a web page / with web connect and visual foxpro database
>
>Any sql samples would be appreciated.
>
>MB


Try:

SELECT clients.* FROM clients
WHERE clients.postalcode IN (SELECT postalcode FROM town WHERE town=)