Help with a table

Sandy,

With tables, input values must be unique (or if the table is bi-directional, both input and output values must be unique).  You’ll need to get a bit trickier and perhaps concatenate some other value (i.e. perhaps a dept code) along with the short-name if you wish to have unique values; i.e.

Input                       Output

ONCPRO                  Oncology Procedure Note

PRO                         Procedure Note

ANESPROCEDURE     Anesthesiology Procedure

PROCEDURE             Procedure

…and so on.

You can have duplicate output values as long as the table is not defined as bi-directional, so if you want to normalize a bunch of different ‘short names’ to a standard long description, that shouldn’t be a problem.

Hope this helps.

Jim Cobane

Henry Ford Health

You may enter the same values on the ‘Out’ side of the table, not the ‘In’ side. Ifyou marked the table as Bi-directional then both sides have to be unique.

Why do you need a table if your intention is to:

For each of these short names, I want to replace with “Procedure Note”.

Wouldn’t it be easier to set up a variable ( @prnote) in xlate to ‘Procedure Note’ and copy it to the field?

Or, you could put the values in a database that has the three columns you really need rather than forcing it into Cloverleafs two-column table with its unique constraints.

Or, given a relatively small list, you could do the same with a simple delimited file.

If you don’t have the bi-directional checkbox selected, you should be able to have duplicate entries on the “out” side.