About Geoff Expertise I specialise in database analysis and design, SQL and database queries using QBE and VBA. In my work, I use MS Access together with MS SQL Server as ETL (Extraction - Transformation - Loading) tools for migrating data between business ERP systems and data stores. My forte is building bespoke functions and applications.
See my
website for example apps and downloads
Experience I am a chartered engineer with 30 years of engineering and business experience, member of the BCS and have been working specifically in database applications, including SQL Server (v7/8/2000) for the last 9 or so years. I previously taught a course in Database Analysis and Design, but am now a freelance consultant and systems analyst.
Commercial database design and development work undertaken.
Question I have a postcode field in one table that will be used for data entry and a list of postcode in another table. I want to create a constraint in the form or table so a postcode cannot be entered that is not in table with the valid postcodes. Can someone help please. Thanks
Answer Luke, hi,
Open the table for data entry in design mode, select the postcode field. Now find the Validate property: use the wizard to build a rule based on the constraint table, eg:
