Hi there,

I am looking for some of your learned advice on the tables and

relatioships

needed for a database for the following:-

A business listing that will allow visitors to search using criteria such

as

business type, county or town(within that county).



Look here for example screenshots

http://homepage.eircom.net/~barrowvaletechnology/

Have a look and tell me if I'm on the right track



A business could appear under more than one business type. e.g.

Company A is listed under 'Builders Providers and DIY Supplies and Paint

Supplies'

Company A is based in Bloggstown, Co. X

There is also a Bloggstown in Co. Y



The visitor will click on a business category and then click on a county

to

get a list of relevant businesses of that type.

Alternatively the visitor may choose county and town to get a list of

businesses in that area.



All help is greatly appreciated

Yours Gratefully

Oliver Dempsey

dempseyoliver@h...