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.

Simple lookup not so simple

buck
in Relationships

Featured Replies

Hi,

I'd really appreciate an extra set of eyes on this one. I'm trying to create 4 product pulldown menus with a respective field next to each that does a lookup and pulls in the corresponding product code. The products need to be in a seperate file from the main database.

I'm very close, but when I select from the first menu, the code appears on all 4 of the code lookup fields instead of just the first. Hmmm.

Any help would be much appreciated, the small file is attached. I think the problem has to do with the relationships, but I'm just stumped.

HappyLookup.zip

Edited by Guest

Each lookup requires it's own relationship.

This is how I did it, but I'm sure there's more ways.

HappyLookup.zip

You may want to reconsider your file structure. But if this is the way you wnat it set up, try this method of using various TOGs.

HappyLookup.zip

  • Author

Those were both exactly what I was looking for. Thank you so much!

Create an account or sign in to comment

https://fmforums.com/topic/38848-simple-lookup-not-so-simple/
Go to topic listing

Important Information

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

I accept

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.