Form A - records contain a reference number and text fields.say A1 A2 and A3, and a lookup checkbox field which takes single line data from the records in Form B.

Form B - simple records which contain only one field, single line text. This is read by form A and C to provide the check box field.

Form C  - Contains another reference number, a few single line text fields, and the same lookup check box field included in form A, reading the records in Form B.

Simples.

But I need to find some way to output information from C, so that it displays the C fields, and the A1 A2 and A3 fields from form A which share the same tick box selection as the C entry? 

For example, lets say form B lists fruit. Form A discribes the fruit, and form C lists the fruit that are in a bowl (?). 

In a record within form C, I tick Apples and Oranges from the tick box selection (i.e the fruit records in B). When I display a fruit bowl record from C, I need it to list the apples and oranges descriptions stored in A?

Sorry if this is confusing. It seems a simple task, which I know should be possible, but its hard to explain.

Thanks