Help with validation rule

[wglmb]

Here's my problem:

Table: PARAMETERS
Field: PARM1
Field: SYMBOL

Table: TRANSACTIONS
Field: DATE
Field: AMOUNT
Field: loads more...

What I want is a validation rule on the AMOUNT field, which says that the data entered cannot be greater than the number in the PARM1 field.
I can't get this to work, and I reckon it's becuase there's one record in the PARAMETERS table, but lots in TRANSACTIONS.
In solving this problem I do not want to add any more records to PARAMETERS. The idea of that table is that it is an easy way to customise the database, not a way of storing data.
I've putting this in the validation rule box (but it didn't work):
=<Tables![PARAMETERS]![PARM1]

Please help!
Thanks

 

[Uncle Gizmo]

You can't do it in the "Validation Rule"

From MS Access Help:
the expression can't contain user-defined functions, domain aggregate or aggregate functions, the Eval function, or CurrentUser method, or references to forms, queries, or tables.

You can view this help yourself, place the cursor in the validation rule box and press F1.

 

[wglmb]

Oh. OK. Thanks!