FrankNewbie Posted May 11, 2007 Share Posted May 11, 2007 (edited) I am a newcomer to FM, tasked with setting up a solution to track foreign language translation assignments. I got a FileMaker book, studied up, and produced a rough solution that has been in use for a couple weeks now. After a few tweaks, most things are working. The translating projects involve specific text segments that go from English into one of a handful of target languages. There is a TRANSLATORS table, where each translator is associated with a particular language. There are several translators that handle Spanish, several that handle Russian, etc. Assignments are made using an ASSIGNMENTS table, and when each assignment comes back, it then gets assigned to a different translator for review, which is also entered in ASSIGNMENTS, then it goes to yet another for a second review. It would be nice (though not essential) to set up a validation that would avoid sending an assignment out for review to the wrong translator. For example, we don't want to send a translated French segment to a Russian translator for review. Maybe I could force selection of reviewer from a restricted list of translators--only those who deal in the target language? Another possibility would be to pop an error message if a wrong translator were picked. Is there a way to do this? So far my reading (book and help), searches, and multiple stabs in the dark have failed to find one. I am flailing. If you would like to see my table relationships: http://www.onizino.com/images/FM-Tx-relationships.gif Any and all suggestions gratefully welcomed. Edited May 11, 2007 by Guest Seemed a bit cocky. I toned it down. Link to comment Share on other sites More sharing options...
Phillip Holmes Posted May 18, 2007 Share Posted May 18, 2007 Hello FrankNewbie A clean way to do this is through a value list that uses a relationship to constrain what is displayed to the user. Search the FM help to read up on value lists. If you have no joy I can email you a sample showing you how it is done. Regards Phillip Link to comment Share on other sites More sharing options...
FrankNewbie Posted May 21, 2007 Author Share Posted May 21, 2007 I read the help on value lists and did find my way to joy. Many thanks to Phillip Holmes for the much needed boost! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6179 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now