I have ODBC to my MSSQL files of my accounting software, Great Plains. I am slowly following the 'logic' of the data structure.
I can add calculation fields and summary fields to aid. I cannot add text fields.
With one table I wanted to add a text field to make notes on the AR Aging.
With a second table, outstanding payables, I want to add a text field as a way to select that item to be included in a special total.
So my next thought was to have a second table to contain any text fields, a one to one table. But I am not sure how to create this. My ODBC information is dynamic increasing and decreasing as invoices are added or paid.