by I am trying to place a validation rule in a field that, if
it is correct, should implement a field that is in the
table. For example, Unit Cost is a field in the table.
The validation I am trying to place is in
field "Materials" rule: if [Item Code]=x, [Unit Cost]
Meaning, place the unit cost in the materials field if the
item code it x. However, Invalid SQL syntax cannot use
multiple columns in a column level check constraint
message pops up.
It says that I cannot use a field within a field? So how
do I separate cost into two categories on the same receipt?
Additional, the field names were pre-established and they
have spaces in them, will this cause an error?