Required Field

[aMack]

I have a date field in my inventory table which is updated by a standard
update query - data from production table with the same ref #.

When I make the date field a required field it does not permit the update
query to run.

What other change do I need to make?

 

[Tim Ferguson]

When I make the date field a required field it does not permit the
update query to run.

What other change do I need to make?

presumably you'll have to supply the date..?

One easy way to do this is to define a DefaultValue for the field in the
table designer window; you can set this to =Date() and it will be filled in
with today's date for each new record.

Otherwise, put the date you want in the INSERT statement.

I can't see why a required constraint shoud affect an UPDATE statement,
unless you are trying to set the field to Null.

Best wishes


Tim F

 

[aMack]

Tim:

Thanks - I made the field default = now() for any new record.

After entering a new record, the date is equal to today but when I run the
update query I get a "Validation rule" violation.

Changing the date field to required is the only change I have made.

Any other thoughts?

Andy

 

[aMack]

OK Tim.

Ignore my last e-mail - the source file had a null value!!!

Thanks

Andy