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.

Lookups in a portal

Featured Replies

I wonder if anyone can help?

I have tried to use the normal lookup function based on various relationship configurations to no avail. Looks like a portal is the way forward but I am not sure if you can use a lookup within the portal

I have 2 Tables

Table 1 Fields

Sample No. 1

Sample Details No. 1

Sample No. 2

Sample Details No. 2

etc up to 10 sets

Table 2

Sample No. 1

Sample Details No. 1

Sample No. 2

Sample Details No. 2

etc up to 4 sets

In Table 2 the Sample Details field is set up as a pop up list based on a concatenated value list of all the Sample No. 1, Sample No. 2 etc records in Table 1. The list of matched returned records is then reduced by a key field which I have called Sample Log Number

What I need to be able to do is to match the sample log number in Table 1 and, say this is in Sample No. 2 field of Table 1 copy the details from Sample Details 2 into Table 2 Sample Details.

Example of Data

Table 1

Sample No. 1W10000

Sample Details No. 1 Location 4

Sample No. 2 W10001

Sample Details No. 2 Location 6

Sample No. 3 W10002

Sample Details No. 3 Location 14

Table 2

We are in the Sample No. 2 field have looked up the Sample No. from Table 1 and selected W10002. We need to lookup the details in Sample Details No. 3, which in this case is Location 14 and copy these details to Table 2 Sample Details No. 2

Any ideas?

Thanks for your help again

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.