Hello, I'm creating a real estate survey system and I'm using a CRUD (phreeze) generator to get the service up a bit, but I have the following question:

I created a table in the database called external area and placed the columns in it:   ID, Item, Type, State, and Note.

In the Item column I have the options for Sidewalk, Trash, Walls, Cameras ... and in the Type column there are several according to the Item column option.

The question is:   how do I create a sort of insert in which I can display to the user all types of sidewalks available?

this is the registration screen

thisisthecode

<?php$this->assign('title','RMVistoriasdeImóveis|AreaExternas');$this->assign('nav','areaexternas');$this->display('_Header.tpl.php');

?>

    $LAB.script("scripts / app / areaexternas.js"). Wait (function () {         $ (document) .ready (function () {             page.init ();         });         // hack for IE9 which may respond inconsistently with document.ready         setTimeout (function () {             if (! page.isInitialized) page.init ();         }, 1000);     });

     External area                                 

<!-- underscore template for the collection -->
<script type="text/template" id="areaExternaCollectionTemplate">
    <table class="collection table table-bordered table-hover">
    <thead>
        <tr>
            <th id="header_IdareaExterna">ID<% if (page.orderBy == 'IdareaExterna') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' /><% } %></th>
            <th id="header_ItemAreaExterna">Item Área Externa<% if (page.orderBy == 'ItemAreaExterna') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' /><% } %></th>
            <th id="header_Tipo">Tipo<% if (page.orderBy == 'Tipo') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' /><% } %></th>
            <th id="header_Estado">Estado<% if (page.orderBy == 'Estado') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' /><% } %></th>
            <th id="header_Observacao">Observação<% if (page.orderBy == 'Observacao') { %> <i class='icon-arrow-<%= page.orderDesc ? 'up' : 'down' %>' /><% } %></th>
        </tr>
    </thead>
    <tbody>
    <% items.each(function(item) { %>
        <tr id="<%= _.escape(item.get('idareaExterna')) %>">
            <td><%= _.escape(item.get('idareaExterna') || '') %></td>
            <td><%= _.escape(item.get('itemAreaExterna') || '') %></td>
            <td><%= _.escape(item.get('tipo') || '') %></td>
            <td><%= _.escape(item.get('estado') || '') %></td>
            <td><%= _.escape(item.get('observacao') || '') %></td>
        </tr>
    <% }); %>
    </tbody>
    </table>

    <%=  view.getPaginationHtml(page) %>
</script>

<!-- underscore template for the model -->
<script type="text/template" id="areaExternaModelTemplate">
    <form class="form-horizontal" onsubmit="return false;">
        <fieldset>
            <div id="idareaExternaInputContainer" class="control-group">
                <label class="control-label" for="idareaExterna">ID</label>
                <div class="controls inline-inputs">
                    <span class="input-xlarge uneditable-input" id="idareaExterna"><%= _.escape(item.get('idareaExterna') || '') %></span>
                    <span class="help-inline"></span>
                </div>
            </div>
            <div id="itemAreaExternaInputContainer" class="control-group">
                <label class="control-label" for="itemAreaExterna">Item Área Externa</label>
                <div class="controls inline-inputs">
                    <input type="text" class="input-xlarge" id="itemAreaExterna" placeholder="Item Área Externa" value="<%= _.escape(item.get('itemAreaExterna') || '') %>">
                    <span class="help-inline"></span>
                </div>
            </div>
            <div id="tipoInputContainer" class="control-group">
                <label class="control-label" for="tipo">Tipo</label>
                <div class="controls inline-inputs">
                    <input type="text" class="input-xlarge" id="tipo" placeholder="Tipo" value="<%= _.escape(item.get('tipo') || '') %>">
                    <span class="help-inline"></span>
                </div>
            </div>
            <div id="estadoInputContainer" class="control-group">
                <label class="control-label" for="estado">Estado</label>
                <div class="controls inline-inputs">
                    <input type="text" class="input-xlarge" id="estado" placeholder="Estado" value="<%= _.escape(item.get('estado') || '') %>">
                    <span class="help-inline"></span>
                </div>
            </div>
            <div id="observacaoInputContainer" class="control-group">
                <label class="control-label" for="observacao">Observação</label>
                <div class="controls inline-inputs">
                    <input type="text" class="input-xlarge" id="observacao" placeholder="Observacao" value="<%= _.escape(item.get('observacao') || '') %>">
                    <span class="help-inline"></span>
                </div>
            </div>
        </fieldset>
    </form>

    <!-- delete button is is a separate form to prevent enter key from triggering a delete -->
    <form id="deleteAreaExternaButtonContainer" class="form-horizontal" onsubmit="return false;">
        <fieldset>
            <div class="control-group">
                <label class="control-label"></label>
                <div class="controls">
                    <button id="deleteAreaExternaButton" class="btn btn-mini btn-danger"><i class="icon-trash icon-white"></i> Delete AreaExterna</button>
                    <span id="confirmDeleteAreaExternaContainer" class="hide">
                        <button id="cancelDeleteAreaExternaButton" class="btn btn-mini">Cancelar</button>
                        <button id="confirmDeleteAreaExternaButton" class="btn btn-mini btn-danger">Confirmar</button>
                    </span>
                </div>
            </div>
        </fieldset>
    </form>
</script>

<!-- modal edit dialog -->
<div class="modal hide fade" id="areaExternaDetailDialog">
    <div class="modal-header">
        <a class="close" data-dismiss="modal">&times;</a>
        <h3>
            <i class="icon-edit"></i> Editar Área Externa
            <span id="modelLoader" class="loader progress progress-striped active"><span class="bar"></span></span>
        </h3>
    </div>
    <div class="modal-body">
        <div id="modelAlert"></div>
        <div id="areaExternaModelContainer"></div>
    </div>
    <div class="modal-footer">
        <button class="btn" data-dismiss="modal" >Cancelar</button>
        <button id="saveAreaExternaButton" class="btn btn-primary">Salvar Mudanças</button>
    </div>
</div>

<div id="collectionAlert"></div>

<div id="areaExternaCollectionContainer" class="collectionContainer">
</div>

<p id="newButtonContainer" class="buttonContainer">
    <button id="newAreaExternaButton" class="btn btn-primary">Adicionar Área Externa</button>
</p>

display ('_ Footer.tpl.php'); ? >