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.

Check Box with more?

cjschulz
in Value Lists

Featured Replies

  • Newbies

Is there a way to build a checkbox field/value list that will give you the option of typing more data next to the checkbox?

For example:

@ will represent the checkbox in the value list - the bold name is the item next to the checkbox and the numbers are what I need to type if that item is checked. These numbers will be specific to the record.

@ UIL 123-456-789

@ VBODA 234-567-891

@ NYSSMA 345-678-912

So if "Amazing Grace"(a record) was accepted at VBODA, I would want to type in the cat. number they give me for that chart. And if "Sonata"(a record) was also accepted at VBODA, it'd have its own number, yet both marked for VBODA.

The way I set it up now is a separate text field for the catalog numbers (from UIL, VBODA, etc) BUT - the reason I want to use checkboxes (and not a pull down menu) is because I'm anticipating the same piece of music getting accepted to more than one list. With the checkboxes, you can mark more than one, right? Therefore, if I left the separate field for the numbers as I have it now, I wouldn't have the numbers relating directly to the prescribed list.

Is this about as clear as mud?

Thank you for any suggestions.

I'd suggest you use a related table for this. So if "Amazing Grace" was accepted at VBODA and at NYSSMA, it would have two related records in this table.

  • Author
  • Newbies

Thanks for the suggestion. I will read about related tables. I'm not sure what that is, actually.

It's probably the most powerful feature of Filemaker. Do spend some time investigating it - I am sure you won't regret it.

  • Author
  • Newbies

Thank you - I have "The Missing Manual" for FM8 and just started looking over this section. Wow. Is that a good source for explaining related tables? I'm a bit overwhelmed right now but I think if I go through the tutorial I can figure it out.

It looks like I've been missing quite a bit from FM!

And here I thought I was doing OK with the huge data base I've created....

I may be back with more Q's

Haven't read it myself, so I cannot say. But it seems popular and you have it, so go ahead and use it. And if you run into problems, post again.

Create an account or sign in to comment

https://fmforums.com/topic/58386-check-box-with-more/
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.