I have a simple statement in LOFresh (Linux) BASE (sqlite3) :
SELECT “tbl_Symbols”.“ID” AS “s.ID”, “tbl_Symbols”.“Symbol” FROM “tbl_Symbols” ORDER BY “Symbol” ASC
I am getting a form load error “ID is ambiguous”. In SQLview the table does show ID not the alias. In the SQLite3 interpreter the alias does show. The SQL tool does not show the header.
I have several subforms and have been trying to sort out the conflict but if the alias is getting ignored; not sure what I should do? Rename all the actual table IDs to a unique?
Thanks for any ideas.
Continuing the discussion from How to filter a table used in a form and remain editable: