Need to pull data from unrelated table - new to Filemaker Pro
I am new to FileMaker Pro, but experienced in Database design. I've ported a database from SQL Server into FileMaker with the assumption that I could make the database structure work in either place, but I am having trouble with one design concept.
My problem is this:
I'm designing factory software to be used both in the US and in China. I have a table containing nothing but the Table and Column name data translated into Chinese, so that I can display the Column names in Chinese and English. The fields are:
I thought perhaps I could set up a calculation field for each field in my regular tables, and pull back the chinese translation of that column name. It would be easy enough to do in a query - "SELECT ColumnNameChinese FROM ColumnNames WHERE TableName = 'Contacts' and ColumnName = 'FamilyName'"
But I can't figure this out in FileMaker.
I'm very new to FileMaker, so I don't even know if this is possible, or if I just don't know enough to see an easy solution.
Thanks for any help!