Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement