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
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Can you match multiple fields to single field in a relationship?

Featured Replies

  • Newbies

Can a relationship be designed to match multiple fields in one table to a single field in another but preserve single match criteria nature?

Problem description: Need to lookup a percentile rank value, from table B for each of 15 raw scores, in table A. Table A includes 15 raw sub-test score fields i.e. math, language, science, reading, etc. Table B includes one raw score field (records contain values 0-100) and a percentile rank field for each of the 15 sub-tests (math, language, science, reading, etc). The obvious solution is to create 15 separate relationships that individually match each table A sub-test raw score to the table B raw score which would allow the lookup of the corresponding rank value. But is there an alternative to avoid creating so many relationships? This test is repeated on 4 separate occasions... that would mean 60 relationships if individually required! Any ideas???

The obvious solution is to create 15 separate relationship

No, I think the obvious solution is to split the 15 score fields into 15 records in a related table.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.