@David
Any chance you would post your dB? You have not provided enough info (relationships, fields, field types) to be able to give you a good example of the code.
I think you have a table "tblFlorist, a table "tblFldetail" and I would think you have a table for customers.
Just a couple of records as examples of the data - change any sensitive data.
Do a "Compact & Repair", then Zip it.