Jump to content
Sign in to follow this  
ralfelvin

More than one value from a vlalue list in one field?

Recommended Posts

Hallo all together,

I just cannot figure out, whether it is possible to insert several values from a value list into one field.

If there a many courses in value list and one pupil is enrolled in many of them, is there a way to choose more than one of those courses from the pop up list or the pop up menu.

Thanks

Ralf from Uganda

Share this post


Link to post
Share on other sites

Yes using a checkbox formatted field does, however is there a violation of 1NF here which dictates "One fact per field" which means that strictly speaking should these choises be broken out in each their own related record, in a many - many structure.

This is classic database theory, but since you're on fm6 could you get some idea on how such matters could be dealt with under the filemaker version you have and earlier:

http://www.dwdataconcepts.com/dl/tw/Many2Many.zip

Well the files are made in .fp3 format, but attempt to open both in your version, and the conversion will take place.

--sd

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Matt Cudmore 
×
×
  • Create New...

Important Information

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