Jump to content

Match multiple word to a translated table


This topic is 1517 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi, 

I have a 3 field, Color, Size, and List3, some words are in English so I made a list of all unique values of all three table, translate it, then past in to a table with field English (original word) and French (translated) 

what I would like is match at those three field with  field in table where all words are already translated. 

 

for exemple Product table  Record 1 /> Color ; red - Size ; eleven - List ; proud

Translated table  

Record 1 /> English ; red - French ; rouge

Record 2 /> English ; eleven - French ; onze

Record 3 /> English ; proud - French ; fier

 

Right now I put a relationship field Color to field English (where all words are translated) 

I would like to avoid making few tables so that s why I asking you guys is there a way to match few words in to one field ?

 

thank you 

Screen Shot 2020-02-02 at 13.44.32.png

Screen Shot 2020-02-02 at 13.45.54.png

Link to comment
Share on other sites

This topic is 1517 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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