1 Reply Latest reply: Nov 3, 2011 7:39 PM by Mike Reese RSS

    Issue using inputfields

    Mike Reese

      I am trying to create a note field and add it to a table.  I've tried this a number of different ways, but every time I try to add it to a table (which has not been created yet), it loses the input funcitonality.

       

      I can create the input field in it's own table with a load * inline and it works fine if I leave it there, but that's not where I need it.

       

      I have tried adding the field to the table I need it in using a left join, but the value turns to 0 (even though was created as 1), and the editing functionality is lost.

       

      I've also tried creating the input field without using an intermediate table.  Following the creation of the field, I create another table with a field matching the name of the input field.  That doesn't work either.

       

      Here are examples of what I tried that don't work:

       

      Ex1.

      inputfield TerritoryNote;

       

      Territory:

      Load TerritoryID,

      1 as TerritoryNote

      ;

      SQL Select TerritoryID from Territory;

       

      inputfield TerritoryNote;

       

      Territory:

      Load * inline [

      TerritoryNote

      1];

       

      Ex 2.

      left join (Territory)

      Load TerritoryID,

      ;

      SQL Select TerritoryID from Territory;