TKnTexas55

ODBC

Discussion created by TKnTexas55 on Apr 27, 2017
Latest reply on Apr 27, 2017 by taylorsharpe

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. 

Outcomes