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

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.