Title
Multiple returns in a single report
Post
I have set up a browse table for a cemetery. I have queried the table for all the graves located within Lot 177. I get 5 returns. I have now set up one a layout to report which persons are in which graves. My layout can take up to ten graves. When I switch to layout mode after querying the browse table, the report has the same person in all ten slots instead of one person in each of the first five slots and nobody in the las five slots. Can anybody help me with this problem. Thank you.
"I have now set up one a layout to report which persons are in which graves. My layout can take up to ten graves."
What type of layout are you using? Form, List, Report with parts, table? You should not be limited to only 'take up to ten graves' so this suggests that you might not be structured properly.
"When I switch to layout mode after querying the browse table, the report has the same person in all ten slots instead of one person in each of the first five slots and nobody in the las five slots. "
What are slots? Are they fields or records? We need to know how you are structured, David. Seeing the same name in 10 slots indicates that the name comes from a related table and the relationship is incorrect. Is this a portal? We need more information to help you through this, specifically table names and how they are related and whether you have multiple fields holding 'like' information such as your suggestion of 10 slots.