SageForum for UK versions of Sage 50- Help and support.

cant i do it through .net code?

If script is the way, which file does it contains this details ?

Thanks

Im using ODBC and with inner join

Select a_h.Header_Number,a_s.Split_Number
From Audit_Header a_h JOIN Audit_Split a_s ON a_h.Header_Number=a_s.Header_Number

but still cannot get parent-child kind of data.

Hello,

Can we get list of companies without using SDO. Dont want to use SDO as it needs user to enable it for older versions

Thanks

Thanks Bruce for reply.

But what iam seeing after join is that
For one record in Audit_Header there is no multiple records in Audit_Split table even we have entered multiple entries through UI.
For every record in Split table there is unique header_number.



Thanks

What does it mean

many usage records are linked to one split by the split_number to the tran_number

does it meane
Audit_Header is parent
Audit_Split is child with header_number as foreign key of Audit_Header table ??

And what is Tran_Number for ??