Autocalculation, lookup, set fields, brings just one word of a text value
I have been trying to bring from a price list table some of the fields into a table that gathers all the quoted items. Since I need to be flexible on the items details, I rather copy the value of the list price into the table than just show the information straight from the price list.
I however, dont konw how to do it, as all the different approaches I have tried, they all bring just the very first word of the original text.
So If in the price list I have a column called: Description, a registry would have a descripction of the item: "TV set of 42 inches..." and so on and so forth.
When I lookup from that table, to paste the contents on the lineitems table (the table that grabs all the quoted items), it just returns "TV"