Field related problem

[clippermedia]

I have 2 db, the master contains 2 fields named "client" and "page num." The other db contains "page num." and "client", ""client2", "client3", "client4". The fields named "client#" are pop-ups using the same value-list.

I want to get the master "page num." field to show me the page number based on the relationship between the master "client" and any of the fields "client#" in the second db.

Thank you

[Jesse Barnum]

Use a multi-key. Make a text calculation that consists of a return-separated list of the 4 client fields. Then use this calculation as the key to the master database. If any of the 4 client fields match the master client field, then the relationship will work.

[clippermedia]

It works! Thank you.

I was making the same without returns.