I am sure this is obvious to all you pros...

[cathyka]

And I hope I can explain this.

I have a Table "Print Specs" with a field called "Final Spec Options". It is a value list check box set.

Example Die Cut, Laminate, Perf etc.

I have a Table "Estimates" with a portal to "Estimate Details" with field "Detail Description" and 'Detail Cost"

I want to create a button that will pre set the "Detail Description" fields based on the contents of the "Final Specs Options" field.

example

If "Final Specs Options" field contains Die Cut - then set field "Detail Description" to Die Cost.

I can't seem to get the If stated correctly...

thanks. c.

[dkemme]

I would not do this with a button, but in define fields. When defining Detail Description, make a calculation, text, case ( Final Specs Options = "Die Cut" , "Die Cost", Final Specs Options = "Second option", "Second Option Cost", and so on ).

[cathyka]

I am lost...

I have my "Detail Description" in a Portal that would allow me multiple combinations for each 'Estimate" record. If I make the "Detail Description" a Calculation I would not be permit to add additional "Descriptions" as needed.

[Slobey]

you probably need a patterncount in your if statement.

If(patterncount;final specs option;"Die Cut");"Die Cost".

of course, youcould make it a calculation just make it auto enter replace, that way you can edit it as well

[cathyka]

Thanks! The pattern count worked perfect In the script I guess I am just missing something in the calculation because I can't that work.