I have a global calc in Table A showing a Max_serial ID field in Table B that increments up one number when a record is added to Table B. Although the Max_serial ID in Table B does increment up a number when a record is added to Table B, the global in Table A does not and remains the same. Is there a way to trigger the global in Table A field to increment up via a script or is there a better calc or other solution for this? TIA

Win XP, FMA9

Use Count( over a cartesian relation instead of using a global!

--sd

Will that allow me to see in table A the Max_serial ID value from table B? I'm a little confused. Thanks,

Ok! max( is a bit safer in case a record or two have been deleted. But still dupe the table B To and tie it to an field in table A via the cartesian. The rest is ...math!

Would you be needing a template?

--sd

Global calculations are stored, and will not recalculate when a record in another table is modified. Use an unstored calculation instead.

Thank you, Soren. That worked great! lpm