I'm converting (and enhancing) an A4 desktop application to A5 using existing data. I've created a set from three tables for invoicing: a parent "Members" table with links to a "Transactions" table as one-to-many, and a "ClubInfo" table as one-to-one with one record of club address information including name and address fields.
I'm in the early stages of developing the Invoice report with only the report page header completed. It seems to be working as envisioned with only a minor glitch ... as I preview the report and move through the members table, the report header reflects the "current" member record. Trouble is ... it's only doing every 14th member! It's acting like I have a filter turned on but I can't locate one anywhere. For the 165 members in the table the report preview only shows 12 pages. When I do use a filter for the 36 active members in the table, the preview only has 4 pages. The good news is they are indeed active members. The bad news ... about 32 members short. And we have little enough active members as it is!
I've hunted around on Alpha Sports and a "Time and Billing" tutorial. I don't see where I've defined my set any differently than what I see on the two examples. I thought it might have to do with the Transactions table since I've not done any detail work on the form and not all the members have items in the transactions. But the preview so far is picking up members unrelated to the transactions. Just getting every 14th record in the members table. Appreciate anyone with ideas on where to look.
I'm in the early stages of developing the Invoice report with only the report page header completed. It seems to be working as envisioned with only a minor glitch ... as I preview the report and move through the members table, the report header reflects the "current" member record. Trouble is ... it's only doing every 14th member! It's acting like I have a filter turned on but I can't locate one anywhere. For the 165 members in the table the report preview only shows 12 pages. When I do use a filter for the 36 active members in the table, the preview only has 4 pages. The good news is they are indeed active members. The bad news ... about 32 members short. And we have little enough active members as it is!
I've hunted around on Alpha Sports and a "Time and Billing" tutorial. I don't see where I've defined my set any differently than what I see on the two examples. I thought it might have to do with the Transactions table since I've not done any detail work on the form and not all the members have items in the transactions. But the preview so far is picking up members unrelated to the transactions. Just getting every 14th record in the members table. Appreciate anyone with ideas on where to look.
Comment