Re: limit number of records with a linked table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



On Nov 8, 10:41 am, Bob Hairgrove <inva...@xxxxxxxxxxx> wrote:
If you had just an
autonumber field, you could put a check constraint on it (i.e. avalidationrule in Access-speak) such as:
" < 9".

If you are advocating CHECK constraint usage, and good for you, then
you can do it properly e.g.

CHECK(9 >= (SELECT COUNT(*) FROM ThisTable AS T2))

Jamie.

--

.