I need help. I have a quotation table which has the columns as:
Model
Description
List
Cost
Markup
and these are also 15 rows down.
and I would like to be able to link certain fields from this table to another on the next page so it shows the same info that is typed. Same as doing a global on a single field. How do you refer in formcalc to a specific field and bind it to another. Please help.
It sounds like you just need to set some Calculation scripts on the other fields that should show some of the information in your table.
Assuming your table is named "Table1", has rows named "Row1", "Row2", ..., "Row15" and each row has columns (fields) named "Model", "Description", "List", "Cost" and "Markup", you should be able to refer to the description of the 4th item like this (in another field's Calculate script, set using the Script Editor palette):
Table1.Row4.Description
Now, whenever the value set in Table1.Row4.Description changes, the referring field's value will change accordingly. You might also want to set the referring field's value type as a "Calculated Read-Only" by setting the "Object palette > Value tab > Type property" accordingly so that the user doesn't attempt to enter any information into it.
Stefan Cameron obtained his bachelor's degree with Honors in Computer Science at the University of Ottawa and is a Computer Scientist working on Adobe's LiveCycle server products, in particular on LiveCycle Designer ES for the past 5 years.