Table Joins in a transaction report

Matthew2624
Matthew2624 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Do you have any record selection rule in place?
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
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

Author

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
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
If you remove the selection formula do you get records and data from both tables?

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial