Select field(s) for printing in layout

[Jason Goldsmith]

Is it possible to allow a user to select which one of two (or more) fields prints on a particular layout?

Thanks!

[Vaughan]

Yes, in a manner.

You can make two different layouts (one for each field) and let them choose the layout to print; or you can make one layout with a calculation field that inserts the field based on the user's selection (in a global field).

[Jason Goldsmith]

Thanks Vaughan,

I like the calculation field suggestion. The problem is that I am making a automated presciption database. There are 15 doctors. When they prescribe a narcotic, I want to include the doctor's DEA number. Either the program would recognize that the drug selection from a value list was a narcotic and enter the DEA automatically (I don't know how to do this) or the doc whould press a button that would enter the DEA number on a layout (or switch to a different layout, as per your other suggestion). Because there are 15 docs, with the layout system. that would be 30 layouts.

Using a calculation field, I imaging it would work as such: Each Doc's DEA # would be in a separate global. Then by selecting one of 15 buttons, that number would be copied and pasted into a DEA# field in the prescription layout.

I have a field (value list) with doctor's names that is selected at the beginning of the users interaction with the database. By selecting a particular doctor, can I reduce the 15 above buttons down to one? I suppose I could use a conditional value list approach. Or I could write a script with the If command and use a calculation with the substitution function - and substitute the DEA# for the doctors name. Each doctor could be a subscript, and I could run through all 15 subscript each time the "Print DEA#" button is pressed. Does that make sense?