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
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?

Do you have any record selection rule in place?
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
If you remove the selection formula do you get records and data from both tables?

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.