filemaker pro 18 advanced fill pattern for a field

Find: All songs with a 'high' effort rating AND a length of over 250 seconds.

Fields on report: Title, Artist, length, genre. Find: All songs with a 'medium' effort rating.Ensure all reports have a suitable title, no 'truncated data' and suitable alignment. Create columnar reports (see instructions below) for each of the following. Evidence: screen shot your completed data entry screen.Add buttons for (i) New record (ii) Delete record (iii) View next (iv) View previous (v) View first (vi) View last.Use the 'Appearance' tab of the inspector to improve aesthetics of your data entry screen (field borders etc).Use the 'Data' tab of the 'Inspector' (View - Inspector) to set the control styles of appropriate fields to 'Drop down lists'.Customise field lengths so that the length of the field is representative of the data that is going to be recorded in it.Use field drag / drop tool to add ALL fields to layout.Evidence: create screen shots to show error messages that your database displays when each of the following INVALID data items is input (i) two records with the same Track ID (ii) a record where the title of the track is not populated (iii) where the year of release is 1959 (iv) where the length is greater than 600 seconds (v) to show your list entry for genre.

Filemaker pro 18 advanced fill pattern for a field