Voljen

Thanks again comment. After this project I'll try to rewrite the database using join table to avoid many to many relationship.

Thank Comment, Your solution doesn't work for me. I've tried to simplify a little more the situation, I think.. Table A has those fields: pKTableA (primary key) and valueA (text value). Table B has those fields: pKTableB (primary key), fKTableA (foreign key populated with pKTableA), other values.. When I was populating table B, I use checkbox input format (that allow to select multiple values) for the fKTableA, showing the related value (valueA) in the field itself. Now, when I try to create a report, filemaker correctly show me the content of fKTableA: the numeric key of table A. I would like to show, instead of a list of numeric values for each record, the list of related text values. The calculation field should make a calculation like this: For each line of the field fKTableA get the number and substitutes it with the related text value. I hope that I explain it more clearly.. Thanks in advance

Hi everybody. I'm a newbie with filemaker, but I'm using it with satisfaction.. Sadly, I've made a mistake with my first project and I'm trying to correct it without changing my database, because now it's been populated. I've create two tables (A and B). In table A I've create a list of value, each of them with a primary key. In table B I've create other records, and in every record there is a field (named "fKTableA") in which I've selected all the values from the table A that are related with the record of table B. The problem is that now I'm trying to create a report, but (naturally) in "fkTableA" there a list of numbers instead of the values. Is possible to create a calculation field that substitutes for each number in "fKTableA" the correspondent value of the Table A? Graphically: NOW fKTableA: 12 Expected results fKTableA: Tizio 34 Caio 25 Sempronio Thanks in advance for your help and excuse me for my poor english.. Alex