information from multiple relationships

[colleent]

I have three relationships built into my file to three different databases but I need them to pull the customer from the first file if not there then pull the customer from the second file and if not there then the third file. How do I define the field in my original file to look in all three places accordingly?

[Ender]

Hi colleent,

It sounds like you have multiple files holding the same type of data (Customers.) If this is the case, you should probably combine those files into one. This would solve your current problem, and many more potential problems.