Hiya,
Is it possible to do this? Logically it seems it should be but it doesn't want to work.
Within my product catalogue table I have a field called "Description".
In this table there is a field for "Product Type" which is a value list, one of the choices being "brochure". Under the Brochure section of the layout are a number of different fields with value lists, about what kind of brochure it is.
I've made the field "Description" a calculation with the following formula:
If (ProductType="Brochure";
(BrochurePages & ", " & BrochureOrientation & ", " & BrochureLamination & ", " & BrochureLaminationOptions & ", " & BrochureFoilOptions & ", " & BrochureDimensions & ", " & CoverPaperWeight & ", " & MainPaperWeight);
WHAT DO I PUT HERE? ).
If the Product Type is not "Brochure", I want to be able to type in the field. What do I put in the formula to allow this? I have tried "" and 0, neither of which work.
The formula result type is set to text.
Help?
Cheers,
Cradders
Is it possible to do this? Logically it seems it should be but it doesn't want to work.
Within my product catalogue table I have a field called "Description".
In this table there is a field for "Product Type" which is a value list, one of the choices being "brochure". Under the Brochure section of the layout are a number of different fields with value lists, about what kind of brochure it is.
I've made the field "Description" a calculation with the following formula:
If (ProductType="Brochure";
(BrochurePages & ", " & BrochureOrientation & ", " & BrochureLamination & ", " & BrochureLaminationOptions & ", " & BrochureFoilOptions & ", " & BrochureDimensions & ", " & CoverPaperWeight & ", " & MainPaperWeight);
WHAT DO I PUT HERE? ).
If the Product Type is not "Brochure", I want to be able to type in the field. What do I put in the formula to allow this? I have tried "" and 0, neither of which work.
The formula result type is set to text.
Help?
Cheers,
Cradders