RJKSolutions

AFTable linked to AFTable

Discussion created by RJKSolutions on Nov 2, 2009
Latest reply on Nov 10, 2009 by spilon

Sanity check please...

 

If I have an AFTable that has a persistence type of Internal, can I link to that AFTable from another AFTable in a different AFDatabase?  I can imagine in the future I could with PI System OLEDB provider but I am thinking right now I can't without something custom built (not an option [:'(]).
I am using the Table Lookup in Attributes for one AFDatabase but now some internal AFTables have data that another project/AFDatabase wishes to use (mostly static data). 

We plan to migrate the AFTables data in question to SQL Server tables and link AFTables that way but thought I would check here first.

On a related note, will we be able to perform join queries on AFTables in the future?

Outcomes