One to Many Table Data
Posted: Thu Jul 05, 2007 9:53 am
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!