Link to home
Start Free TrialLog in
Avatar of Matthew2624
Matthew2624

asked on

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
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Do you have any record selection rule in place?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Matthew2624
Matthew2624

ASKER

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

mlmcc