Multiple Records returned in a relationship
I have a relationship set up between to tables in two different files. Often, there are more than one record returned that fit the relationship. How do I tell the first file which record I want it to use from the second file. As an example, I have a customer invoice for the first file which automatically grabs pricing information from the second file. Both files use the date to relate to each other as the pricing information is changed daily. My industry has been very volatile lately and I am thinking about changing the pricing information through out the day. I cannot seem to figure out how to tell the Invoice file to grab the most current record in the pricing file.
Any help would be great,
Thanks in advance,