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
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
Do you have any record selection rule in place?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
@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
mlmcc