Multiple records in a field 1

[Skiphan]

Hi,

I have two tables, a table with characters and a table with words (Chinese language).
I'm making a report that lists all elements in table characters, and I want to have a column 'As in' in the report that shows all the words (from the table with the words) where the character exists in.

But how can I do the latter?

Thank you for reading.

 

[Remou]

I am not quite sure I get what you mean, perhaps:

[tt]SELECT tblSentence.Sentence
FROM tblSentence, tblWords
WHERE ((InStr([Sentence],[Word])>0));[/tt]

 

[Skiphan]

I made the query:

SELECT Karakters.Karakter, Woorden.Karakters
FROM Woorden, Karakters
WHERE ((InStr([Woorden.Karakters],Karakters.Karakter))>0);

and it gave the following result, which is good:

But I don't know how to link the query with the textfield in my report.
It asks for a parameter and if I don't enter it I get an error:

I want the textfield to be filled with all the results from the query per character.
I hope it is more clear now.
Thank you.

 

[Remou]

The easiest thing to do would be to replace the textbox with a subform based on the query. You could set the link child and master fields to Karakter. Would that suit?

 

[Skiphan]

This subform based on query is what I needed.
Now I have the desired result:

Thank you very much!