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.

Conditional Value List Relations Problem

Featured Replies

  • Newbies

Hi,

I am using Filemaker Pro v.9 Advanced. I have database I need to get done and am having a hard time with the relations for a conditional value list. It is based off of the Issue Tacking sample that comes with the software. So what I have done is created some tables. There is the issue traking. Then I created a Company table, Address Table and a Contact Table. What I am trying to do is if a company is entered and it is already in the list it can be chosen. That works fine. But each company could have multiple Addresses and some are overseas. So in the Address Table I have these fields: Company, Attention, Address, Address2, City, State, Zip, Country, and Contact. The Company Table has Company. Now each Address for Each Company could have Multiple Contacts. So I created a Contacts Table with the Fields: Name, Phone, and eMail. So if you can see I want to be able to select the company on autoenter if it exists and populate the address. But if there are multiple addresses I would like to select the address or type in a new one, which the new one would be included in the future. And if the address exists and is chosen be able to chose the contact if there are multiple ones for those addresses. So if anyone knows how to help I would appreciate it. I have been looking for example but haven't found any yet.

Jason Boes

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.