General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for the advice, John.
On the Table side,
In the table definition I set a default value addnum+" "+prefix+" "+ALLTRIM(addname)+" "+addtype+" "+addapt
I don't see any 'on save' properties here.
On the form, I tried putting the same formula in the InteractiveChange Event.
This doesn't do what I expected either.
Can you point me to an example or tell me where I get to 'on save'?
>Sounds like a data issue, so the answer depends on how you save data. You should create the old long address from the new data on save.
>
>>My client used to have one big 'address field', and now they want in to input/maintain it split up. So they added fields called Streetnum (eg, 11200), Streetname (eg, Main), Streettyp (eg, St.). But, they want to keep the address field for backward-mobility purposes.
>>
>>As they type the split-up values, they want to see their old address field get filled in. Should I approach this as a form issue, or something at the database?
>>
>>Thanks.
>>Humble newbie,
>>Sylvia
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only