Printing Report - 1 Element in a Many-to-Many relationship
I have a letter that I print using the information from my database. This particular letter is to a parent of a student. Since the student can have more than 1 parent and more than 1 student can have the same parent(s) I have a many to many relationship. When I enter the elements on the letter, if a student has two parents in the database only one letter is printed, but it contains both parent information in the same letter. For example (Dear Mr.Ms. MaloneMalone). I tried to add an checkbox to each parent record called "primaryContact" and then limit it using the expression [primaryContact=true] but it says it does not return multiple results. Is there any way to either print two letters (one for each parent) or restrict it to a specific parent of my choice? Thank you for your help in advance.
4 replies
-
Try using the item() function, ie, item(table.field, index #). There was a recent thread where I was able to separate the records using this function instead of select().
-
I did test it in print layout mode and it works with the reference fields. I added a formula to the print layout and used this as my formula...
{item(Vendor.Name, 0) + "" + item(Vendor.Address, 0) + "" + item(Vendor.City, 0) + ", " + item(Vendor.State, 0)}0 represents the first record, 1 the second and so on.
-
Awesome. Thank you
-
This worked perfect.
Content aside
- 5 yrs agoLast active
- 4Replies
- 1635Views