Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Selecting records for merge fields

Followers

December 13, 200520 yr

Newbies

I have a simple database with two tables: People and Donations.

The People table contains contact information on donors. The Donation table contains records of each donation. The two tables are linked via a Person ID number. The list of donations from the Donation table appears in each record in a layout in the People table via a portal. All of this works fine.

I want to create a letter as a layout in the People table and use data from a field in the Donation table in that letter as a merge field. I have been able to do this successfully EXCEPT if more than one Donation record exists for a donor, I have not been able to figure out how I can select the specific Donation record I want to appear in the merge field.

Help and advice will be much appreciated.

Edited December 13, 200520 yr by Guest