Generally, you don't want to duplicate data, as it defeats the purpose of having a database. If you explain what you're actually trying to do, we can probably give you a better solution.
Both the list and ExecuteSQL functions can produce delimited lists from a group of records.
Hi Jason Wood,
Thank you for your reply, I need to build a dashboard that contains many charts. I have found an example (manycharts) in this community. The example is good but charts data the data is being set directly by the user, what I am looking for is a way to make charts data been set by a script.
hope it clear enough and again thanks for your help
Phil's suggestion to use ExecuteSQL should be perfect for pulling together what you need. You do not need a new table.
1 of 1 people found this helpful
To expand on this, when you specify your Y and X series, you can set them up as calculations that use either ExecuteSQL or list instead of storing the data in a field. However, if you find that it takes a long time for the screen to update, storing in a field might be faster if you don't need to update the chart every time you bring up this layout.
Thank you very much.