AnsweredAssumed Answered

Need to pull data from unrelated table - new to Filemaker Pro

Question asked by AmeliaLangston on Mar 24, 2011
Latest reply on Mar 24, 2011 by AmeliaLangston

Title

Need to pull data from unrelated table - new to Filemaker Pro

Post

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:

ColumnNameID

TableName

ColumnName

ColumnNameChinese

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!

Outcomes