Jump to content
Sign in to follow this  

Flailing to Validate

Recommended Posts

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:


Any and all suggestions gratefully welcomed.

Edited by Guest
Seemed a bit cocky. I toned it down.

Share this post

Link to post
Share on other sites

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.



Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.