QuickBooks Table Linking Issue

[Chip]

I import data from our QB file via QODBC. The acquisition of the data is fine and we are able to use the data in many ways. One problem that I am having is finding a way to reference but linking the EstimateLine table records to the SalesOrderLine table records. There no field that I can find to use to join the two tables together in a query. There is a table in QB that is called EstimateLinkedTxn that is similar to a table called SalesOrderLinkedTxn that contain records that link a record in the SalesOrderLine table to records in the InvoiceLine table. But the EstimateLinkedTxn table, unlike the SalesOrderLinkedTxn table does not contain any records. Has anyone else come up against this issue with QB? If so, I would appreciate any help you can offer.

Thanks,

[victorydata]

I import data from our QB file via QODBC. The acquisition of the data is fine and we are able to use the data in many ways. One problem that I am having is finding a way to reference but linking the EstimateLine table records to the SalesOrderLine table records. There no field that I can find to use to join the two tables together in a query. There is a table in QB that is called EstimateLinkedTxn that is similar to a table called SalesOrderLinkedTxn that contain records that link a record in the SalesOrderLine table to records in the InvoiceLine table. But the EstimateLinkedTxn table, unlike the SalesOrderLinkedTxn table does not contain any records. Has anyone else come up against this issue with QB? If so, I would appreciate any help you can offer.

Thanks,

The only reference that is created, as far as I see, is going to be in the SalesOrderLine Memo field. Unfortunately the estimate number is accompanied by additional text in the memo field (ie "Estimate ####:" It would be better if it was an isolated figure. My workaround for this issue is to create a custom field and add it to the Sales Order form and manually enter the estimate number there so it will be isolated, which can then be manipulated without having to deal with the extra text.