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