Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Best Design Method

    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?
    Best Regards,

    Luke

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,533
    Thanks
    0
    Thanked 23 Times in 23 Posts
    I have just developed a very similar database here in Australia.
    I don't know what you mean by the last question?

  4. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Best Regards,

    Luke

  5. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,533
    Thanks
    0
    Thanked 23 Times in 23 Posts
    I wouldn't use yes/no boxes for a new area, I would use a combo box

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •