I’m new to DNN and just started looking at 4.0.3.  I’m working on a site for a non-profit organization and one of the features needed is a sponsor-a-child listing.  I’m looking for advice on a solid approach for building the sponsor a child database/list and presentation on DNN.  At a minimum we need to

-         allow a non-technical content admin to manage the entries in the list, which includes uploading an image of the child.  So the ability to add rows to the list for the admin must be simple.

-         Display rows in a paging format with a clear row separator (this is the display of children to be sponsored)

-         Filter the result set based on selected values (male/female, sponsored/unsponsored)

-         If a child is unsponsored then enable a link to a form where we can display the same child data and allow the user to express an interest in sponsoring the child

I have looked at the UserDefinedTable and the gammaCon.userDefinedTable but neither of them allow for filtering the rows in the result set.  I’m not yet familiar enough with DNN to understand how we can build this functionality ourselves (I’ll get there eventually but would like to offer them a near-term solution).

An example of what we’ll be replacing with DNN is located here.

http://www.henryvargas.com/cgi-bin/db/hope.pl

Any advice on an approach to this type of functionality would be greatly appreciated. 

Thanks!

Justin