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;
