Default value using SQL

[SkydivingSteve]

When a new record is created, I want the value of a field to be the greatest value of the fields in that table (i.e. SELECT Max(order) FROM story; ). However when I enter the SQL into the default value, I get an error message when saving the table (The syntax of the subquery in this expression is incorrect.)

Any ideas?

Steve

"In the Jungle of the Senses

 

[BNPMike]

Where are you entering this?

 

[SkydivingSteve]

Design Table -> Data Type (Number) -> Default Value

I'm not using the Expression builder but entering directly into the Default value entry box.

Thanks for your help!

 

[BNPMike]

I've got a feeling you can't use selects in this context. I've a feeling you can only refer to other things in record constraints rather than field constraints.