One to Many Table Data

[Cyndi_Egbert_(Guest)]

We need to include a field in a report which may contain multiple results. We have a clear one-to-many index with a single-field primary key in the primary table and a combination of that ID plus another field as the primary key in the secondary table.____When I call up the primary key from the primary table, I need all matching records from the related table to show in the report. I set the table relationship up as a one-to-many relationship, and used the standard index file available, which is accurate (arnum in first table relating to arnum+species in second table).____What I get in the report is, at best, a single result when I insert the field "species" in the report band, rather than the entire listing. How do I set up the field to return all results (on the same page in the same band) rather than just the first one it finds (if it will return any at all)?____Thanks for your help!

[Cyndi_Egbert_(Guest)]

I forgot to state that we are using R&R for Windows, Xbase Edition, Version 12, Build 12.1.001.

[kfleming]

Did you place the fields from the related table on a record band line in the report? And did you re-check to be sure that the relation is set to Scan (1 to many)?____Kathleen__R&R Support