Hello, I have the question It's possible AF Table as a data source for the other AF Table? I have some tables with statics values but I need build a new Table with some data the others.
Sadly I don't see how this can be done.
AF Tables can get data from external sources using ole db connections and AF can be accessed through an OLE DB connection using PI OLEDB Enterprise, but the content of AF Tables are not accessible form PI OLEDB Enterprise.
So, it is not possible to do this through even a round about way.
(The tables content would be if exposed as the value of an attribute, but creating such attributes to expose all the data would be nightmarish I think).
Once you need tables that refer to other tables, what you really need is a proper relational database to handle this content. Even Microsoft Access would surely meet your needs.
Once that data is moved to a proper relational database, you can then use AF Tables to query this data and expose it in AF.
Hi Jerome, thank you for your answer , I had understood the better form to fill any AF Table through OLE DB connection or other sources database connections.
Retrieving data ...