Jump to content
Sign in to follow this  
camitz

Set field in lots of records

Recommended Posts

New to FileMaker, been working with sql-based databases before and can't really get my head around a few things.

A basic contact register: You've got a contact layout and a portal with phone numbers, an unlimited number. I've got the relationships setup etc.

One of these phone numbers is the primary, so you got a checkbox. But only one of these can be set at a time. So when the user checks one, all the other have to go unchecked, for that particular contact.

How do you do that?

Much obliged.

Martin

Share this post


Link to post
Share on other sites

I store the ID of the preferred phone in the Contact record. I script the checkbox to set the ID.

Share this post


Link to post
Share on other sites

So when the user checks one, all the other have to go unchecked, for that particular contact.

Strictly speaking is this a radio button metaphor not a check-box ditto....

But Barbera's suggestion is otherwise succinct and to the point correct.

--sd

test.zip

Share this post


Link to post
Share on other sites

I can only agree that Barbara's solution is very good. I might say the same about you're language, where'd you learn the word succinct?

Bad example, but learning how to do this with a script I feel will be useful, I'm sure of it. What if you have two primaries? (The example is really flawed now). Or better yet, a user determined number of primaries? Can it be done?

Share this post


Link to post
Share on other sites

Camitz, two primaries? Certainly, Soren will post a link to a dictionary, lol.

I think that you are alluding to the fact that you'd like to go down a list and "mark" records. This technique of adding and removing record IDs from a global field can be found here: Multi-user Marking .

Share this post


Link to post
Share on other sites

:

1400–50; late ME < L succinctus, ptp. of succingere to gird, gather up (one's clothes), prepare for action, equiv. to suc- suc- + cing(ere) to gird, equip + -tus ptp. suffix

or...:

http://en.wiktionary.org/wiki/succinctus#Latin

But Barbara used, the old Jeff Almquist way ... why not exploit a very usefull CF in this context:

http://www.briandunning.com/cf/39

...since your solution often can benefit from it in various methods you wish to throw after a solution.

--sd

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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