Best Design Method

Topic

New Reply

Good evening.

I am reviewing our property database and bringing in new features and addressing old quirks, etc.

One of the areas I feel needs to be improved is our matching. Basically we are an estate agents in the UK and store our purchaser information including prospective clients and match them to property’s.

At present the property field will have information that we like to search such as

Price
Area the property is in
Bedrooms
Type

In the purchasers table we store their wants as yes/no boxes. So for example we have a yes/no for detached, semi-detached, etc. we then have a yes/no box for the different areas (upto 20 areas+)

The price and bedrooms are easy field as these directly match in terms of a number field. So if they need a minimum of 2 bedrooms, it will return properties with two bedrooms plus. Similarly with the price.

How would someone change this from a table layout and GUI layout?

Reply | Quote

Replies

I have just developed a very similar database here in Australia.
I don’t know what you mean by the last question?

Reply | Quote

Okay.

Not made myself clear.

I wondering how someone would set this kind of setup in a database environment. The problems have is if we add a new area into the database as the areas are stored within a table ‘tblarea’ i have to make design changes to the form and create a new yes/no box and roll out the new front end to users. I also have to change the programming behind the yesno box to take into account that this now needs to feature as part of the query.

Reply | Quote

I wouldn’t use yes/no boxes for a new area, I would use a combo box

Reply | Quote