Hi

What I'm trying to do is to set a range of fields from one field's oncreate script.

I have an address line 1, address line 2 ...

I want to do a SQL lookup on address 1 and from there set the value for address line 1 and address line 2 etc etc.

I know about the DefaultValue property, but that will imply a sql query on every field. I want to minimise traffic to the db.

Is what I am trying to do possible?

Please assist.