Table Joins in a transaction report

I have a transaction table that is the main table see attached glf_ldg_acc_trans which has all the transactions, I then have a Billing Table attached to it that has certain linked data but does not relate to every transaction in the glf_ldg_acc_trans table. When I add in a field from the billing table it only shows values that are in both tables. I change the join properties to

Join Type -  Left Outer Join

Enforce Join - Not Enforced

Link Type -  =

Not sure what else I can do to show all records from the main table while using the vales from the secondary table that are in both tables.

See screen shots in the attached
table-join.jpg
Matthew2624Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
You may have to change th eother tale to also be LEFT OUTER JOIN

Are you sure both fields are required for the join?

mlmcc
0
 
peter57rCommented:
Do you have any record selection rule in place?
0
 
Matthew2624Author Commented:
@ Peter57r - only selection rule is to choose one accnbri which is the account number.

@mlmcc yes they are required, one is the account number and one is the document reference
0
 
mlmccCommented:
If you remove the selection formula do you get records and data from both tables?

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.