which field to print

[Robbydobbs]

I have two layouts in the same database. One is miscellaneous and the other is data entry. Miscellaneous has a field call misc_desc and data entry has a field called data_desc. Now as it stands when I print out an invoice only the information in the data entry field data_desc is printed. But now I want to say that if the layout miscellaneous has information in the misc_desc print that information out on the invoice, but if the layout data entry has information in the field data_desc print that field out on the invoice. Both layouts would never have information in their fields at the same time, its either going to be one or the other.

Is this possible to do and if so, how would I do it?

[Wendy T]

create a new calc field to check which field is holding data.

If(IsEmpty(misc_desc), data_desc, misc_desc)

then use this field on your invoice layout.

cheers,

Wendy

[CobaltSky]

Hi Robbydobbs,

Both layouts would never have information in their fields at the same time, its either going to be one or the other

If that's true, then why have separate fields for the descriptions? You may well be able to simply place the same description field on both layouts - in which case the description will always appear on the invoice regardless of which layout it was entered on.

Notwithstanding Wendy's suggestion, unless there is something else you haven't told us, a 'one field for both layouts' approach would seem to be simpler all 'round.

[Robbydobbs]

Excellent Wendy. Thank you for the great insite. That's exactly what I needed.

Thanks again.