I have a simple database with 2 tables. a) Florist, a list of purchasers of items and b) Fldetail, the lists of items purchased by one or more of the purchasers.
The Main form is called Invoice and contains all of the purchaser information as well as various text fields with some static information. The SubForm ReportFldetail contains information about individual purchases for each
purhaser.
Queries are created on both Florist and Fldetail to fill in the main form and the subform. The two forms are linked with an ID field.
So far, everything works perfectly, and all of the information I want is presented correctly for each purchaser.
The problem that I have been unable to solve is that the report gives a record for every purchaser in the database including those who have not purchased anything. I have tried everything I have come across to
eliminate these unwanted records, but have had no luck.
I am thinking that the solution could be done by creating the combined tables with a join, but have not been able to do anything with this.
Any suggestions would be greatly appreciated.
David Wright Sr.