/*
 * Author       : noemie
 * Generated on : 22-Nov-2009 22:04:13
 * Version      : 3.0
 */
application "Notes"
{
    type = public
    date format = "dd-MMM-yyyy"
    time zone = "America/Los_Angeles"
    section Home
    {
        form  Eleves
        {
            
            must  have  Prenom
            (
                type  =  text
            )

            must  have  Nom
            (
                type  =  text
            )

            Eleve
            (
                type  =  formula
                value  =  Prenom
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  Eleves_View
        {
            displayname = "Eleves View"
            show  all  rows  from  Eleves 
            (
                Prenom
                Nom
                Eleve
            )
            options
            (
                display rows = 100
            )
        }

        form  Matieres
        {
            
            must  have  Matiere
            (
                type  =  text
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  Matieres_View
        {
            displayname = "Matieres View"
            show  all  rows  from  Matieres 
            (
                Matiere
            )
            options
            (
                display rows = 100
            )
        }

        form  Controles
        {
            
            must  have  Matiere
            (
                type  =  picklist
                values  =  Matieres.Matiere
            )

            must  have  Date__field
            (
                displayname  =  "Date"
                type  =  date
            )

            Controle
            (
                type  =  formula
                value  =  Matiere
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  Controles_View
        {
            displayname = "Controles View"
            show  all  rows  from  Controles 
            (
                Matiere
                Date__field as "Date"
                Controle
            )
            filters 
            (
                Matiere
                Date__field
            )
            options
            (
                display rows = 100
            )
        }

        form  Notes
        {
            
            must  have  Eleve
            (
                type  =  picklist
                values  =  eleves.Eleves.Eleve
            )

            must  have  Controle
            (
                type  =  picklist
                values  =  eleves.Eleves.Eleve
            )

            must  have  Note
            (
                type  =  number
                width  =  20
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  Notes_View
        {
            displayname = "Notes View"
            show  all  rows  from  Notes 
            (
                Eleve
                Controle
                Note
            )
            filters 
            (
                Eleve
                Controle
            )
            options
            (
                display rows = 100
            )
        }

    }

}