Jump to content

Anding relationships


This topic is 8290 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I think what you are asking is to base a relationship on more than one criteria, such as matching customer number AND date. It is really easy to do this by creating calculation fields in both files that combines the two fields, and then basing the relationship on that calculation filed.

for example:

file1:

Join Field1(calc) = Customer_Name1 & "-" & datetotext(date1)

File2:

Join Field2(calc) = Customer_Name2 & "-" & datetotext(date2)

and then base the relationship on join field1 and join field2

~Ati, Jedi Master

the force will be with you, always

Link to comment
Share on other sites

Two things to remember. First, never use a customer name to connect information in two files. The first time someone changes "Robert" to "Bob" or corrects a spelling error, the links will be broken. Second, is you use a "-" in combining two fields, make sure you change the indexing from "English" to "ASCII" or the dash will be ignored.

-bd

Link to comment
Share on other sites

This topic is 8290 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.