AndrewS

4 years agoQrew Trainee

# FULL JOIN 2

My firs topic wasn't resolved, so will try to provide more info about my Tables and Relationships:

'Budgets' has many 'Budget lines' (connected thru 'Estimate' field)

'Estimates' has many 'Budgets' (connected thru 'Estimate' field)

'Estimate Lines' has 'Estimate ID' and could be connected to the 'Budgets Table',

but

'PO Lines' does not has 'Estimate ID'

'Categories' has many 'Estimate Lines' and 'PO lines' (to assign the category)

so, I would like to have Summary and Chart report that will include data from 'Estimate Lines' and 'PO Lines' tables.

'Estimate Lines' and 'PO Lines' tables synced to the QuickBooks

will appreciate any help...

------------------------------

Andrew S

------------------------------

'Budgets' has many 'Budget lines' (connected thru 'Estimate' field)

'Estimates' has many 'Budgets' (connected thru 'Estimate' field)

'Estimate Lines' has 'Estimate ID' and could be connected to the 'Budgets Table',

but

'PO Lines' does not has 'Estimate ID'

'Categories' has many 'Estimate Lines' and 'PO lines' (to assign the category)

so, I would like to have Summary and Chart report that will include data from 'Estimate Lines' and 'PO Lines' tables.

'Estimate Lines' and 'PO Lines' tables synced to the QuickBooks

will appreciate any help...

------------------------------

Andrew S

------------------------------