Subform linking to multiple child fields

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
 
M

meyerryang

I figured it out on accident.

In the master field enter [USERNAME]
In the child field enter [Sales Rep 1] or [USERNAME] = [Sales Rep 2]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top