PelicanProductions

Ah yes, I went wrong the most obvious way I could. Works great! Thanks!

I must have misunderstood somthing, if I put "itself" where I had "VARIABLE?" it just replaces all of the valid fields with the text "itself". Where did I go wrong?

I am trying to create a SetField script step that validates a records status and changes the status to "Renewal" if the record has expired, here is the calculaton: If ( RunSheet_PP::Date >= RunSheet_PP::Validate; "Renewal";"VARIABLE?" ) Where I have "VARIABLE?" I am looking for a value that will leave the fields existing value unmodified. Please help. Using FM Pro 8.5 advanced Thanks

I am trying to get a predefined label layout (Avery 5160) to display a printable page in instant web publishing. Currently when I publish the database the labels view lists records in a single column instead of the three column layout as in appears in FMPro. Any ideas?

Hello, I am building a subscription database for a quarterly publication and need to be able to identify records for expiring subscribers. The database contains a field for ending issue but the issue is identified by season and year ie. "Summer 2007". How can I specify that "Summer 2007" equals a specific date or date range without renaming the values in the field? I am trying to create a script that will identify only expiring records. Please help if you can, I am a graphic artist & web designer by trade and this database stuff is new to me.