Relationships issue

[the606]

Hi,

 

Been working on database for years but just started on Filemaker Pro Advanced 12.

 

Im designing something for a friend and im having trouble setting something up as I cant seem to get it clear in my head.

 

So basically I have a couple of tables, one of which contains all of the 'customer' information (customer id, name, address etc).

 

I have another table with some reporting entries in it, these are in two languages as I need to allow the account manager to select the English comments but the equivalent foreign language comment is saved against their 'record' (in another table with the year as a key as this will not get updated).

 

Im having trouble setting up a new layout to select the comments but actually save the foreign language version......

 

I think im a bit slow today

 

Any help would be greatly appreciated.