I have completed the review of this chapter. I have a couple of problems:
Page 5
The description of the two forms and their interaction with the views, tables etc is not clear. I was able to follow it up to the creation of the forms. However the document uses *Update form*function. I was unable to find this in the Actions part of the menu. I could only find *Refresh Form.*
The description in this section really does not make it clear what the object of the exercise is.
I have been working with databases for about 30 years, and have never needed to use filtering of this type and have so far not been able to understand what the purpose is.
Page12
The only other problem I had was with the final query on page 12;
SELECT "Surname",
( SELECT "Firstname" FROM "View_Group" WHERE "Surname" = "a"."Surname" AND "GroupNr" = 1 ) ||
IFNULL( ( SELECT ', ' || "Firstname" FROM "View_Group" WHERE "Surname" = "a"."Surname" AND "GroupNr" = 2 ), '' ) ||
IFNULL( ( SELECT ', ' || "Firstname" FROM "View_Group" WHERE "Surname" = "a"."Surname" AND "GroupNr" = 3 ), '' ) ||
IFNULL( ( SELECT ', ' || "Firstname" FROM "View_Group" WHERE "Surname" = "a"."Surname" AND "GroupNr" = 4 ), '' ) ||
IFNULL( ( SELECT ', ' || "Firstname" FROM "View_Group" WHERE "Surname" = "a"."Surname" AND "GroupNr" = 5 ), '' )AS "Firstnames"
FROM "View_Group" AS "a"
This returns a row for each record in the View_Group. The query need to be modified to
SELECT DISTINCT ''Surname“ , …...
The modified query (page 12)can easily be either added to or substituted for the existing query.
I have no idea how to deal with the form interactions on page 5.
I have considered making the change to the query on Page 12 and adding a reviewers comments at the end of the document. Any advice on dealing with this will be gratefully received.
Regards
Peter Goggin