Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
ODBC - Linked tables not returning fields/changing over time?
Using MS Access ODBC, I'm experiencing a situation where my linked tables have changed and no longer contain the fields they used to. Previously the linked table had fields "sorted" by most frequently used fields, now the table is displaying an alphabetical list, truncating somewhere mid-alphabet.
So for example, where the table previously contained:
Customer_ID
Companyname
Sales_Rep_ID
Address_line1
...
etc.
It now displays:
Address_line1
Address_line2
Companyname
...
etc., and will be truncated at some point in the alphabet
As a result, I have queries that join the sales_rep_id field to another table, which fail as the joined field doesn't exist in the table anymore (?!)