Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
alter field in Dbase based on othe rfield values
I want to have a NAME field in my table that is based on three other fields - FIRSTNAME, LASTNAME, COMPANYORG.
If COMPANYORG is blank, then NAME=LASTNAME, FIRSTNAME.
If not blank then NAME=COMPANYORG.
I do this right now in various parts of my customer maintenance screens. What I want to know if there's a really neat way to do it inside the database itself using a stored procedure or validation rule, or something else I don't know about...
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