Creating a Database Homepage
I want to create a homepage for my photo database, that provides an easy location from which to access the most useful forms and search functions. I have created scripts to link to these pages and change the view mode where necessary. Aside from the links, I also want to show 5 random photos from my entire collection, and 5 random photos from those with a high rating (i.e. the field "rating" = 5). I also want to show some key database statistics on the homepage (e.g. No. Photos, No. unique values for particular fields, 5 most common values of particular fields etc). Finally, I would like to have a search function on the homepage, where I can search for values in particular fields but also a "keyword" search that searches all the fields.
My questions are:
- Would this layout best be achieved in the Browse mode? If not, which mode would be best?
- How do I go about returning the random records?
- Is a search feature possible in Browse mode (assuming that this is the best mode for the layout)?
Many thanks to all who can answer, I have learned so much in such little time thanks to you all!