M
meyerryang
Is there anyway to link the Master field to multiple child fields, but not
include both as required criteria.
For example if I have Sales Rep 1 and Sales Rep 2 as two different fields
and I want the subform to show me all records where the Sales Rep 1 (child
name 1) is equal to the Username (master field) and include all fields where
Sales Rep 2 (child name 2) is equal to the Username.
Sales Rep 1 Sales Rep 2
Bob Smith Kyle Thompson
Kyle Thompson
I want Kyle Thompson to see both his records. Is there a way to change the
child master to include one or the other criteria?
child field: [Sales Rep 1] or [Sales Rep 2]
master field: [USERNAME]
Thanks in advance
include both as required criteria.
For example if I have Sales Rep 1 and Sales Rep 2 as two different fields
and I want the subform to show me all records where the Sales Rep 1 (child
name 1) is equal to the Username (master field) and include all fields where
Sales Rep 2 (child name 2) is equal to the Username.
Sales Rep 1 Sales Rep 2
Bob Smith Kyle Thompson
Kyle Thompson
I want Kyle Thompson to see both his records. Is there a way to change the
child master to include one or the other criteria?
child field: [Sales Rep 1] or [Sales Rep 2]
master field: [USERNAME]
Thanks in advance