Does anyone have any suggestions for printing when there are details in more than one child database?

I am making a solution to record liens registered on vehicles.

The parent db records who registered the lien, how long it is for, and how much is owed.

The first child db records who owes the money - the debtor. There can be multiple debtors per lien.

The second child db records the vehicles the lien is registered against. There can be multiple vehicles per lien.

How can I make a layout to print a report that shows the main info from the parent, the details for all of the debtors, and the details for all of the vehicles?

You'll need to combine some of this information into singular fields so that you can display them on the report. I would suggest either using the Troi text plugin, which can summarize text from related databases into a single field or create a value list and use the ValueListItems () design function to gather the items into a single field.

Very Cool!

I used the value list.

Thanks!

I recently found a shortcoming with the ValueListItems () method: I had a situation where two (or more) related files had equal values. The resulting value list "filtered" these out, a result of the indexing process.

I worked around it by concatenating a unique ID onto the value in the related file, then calculating it out in the master record's calculation. It worked! (I impressed myself that day!)