Hello everybody,

Can't get rid with the following question

I created a database for composers

::Composers

::Nationality

When adding Beethoven to Composers table, I realised he had two nationalities, German and Austrian. I have no idea how to relate my record to the national table. Please help.

Cori

Ok, I am not thinking in a relational table

:Composer to nationality

And I dont want a multiple value checkbox field.

It would be nice to have

::Composer

ComposerID

Composer_nationality1 (value from ::Nationality)

Composer_nationality2 (value from ::Nationality)

Have you use Checkboxs for the Nationalities?

What I want is to implement a tag system, nationalities is just a start. Checkboxes for 100s of tags is a bore. Suppose I want to assign Johann S. Bach, not only to Germany, but also to Prussia, Dresden, Leiptzig and Weimar, by the time independent States. Cant do that with checkboxes.

Ok, just created the following

:Nationalities

name

::Composers

nationality1

nationality2

Made a X relationship between the two tables

Created a portal and filtered as

name = nationality1 or name = nationality2

It worked.

My question is, if this procedure is praticable for large amount of records, said 500+

My question is, if this procedure is praticable for large amount of records

Not really (although 500 is hardly a "large amount of records"). You should try using a join table - see an example here:

http://www.fmforums.com/forum/showpost.php?post/246136/

Hi comment, thanks for your reply. Have a joint table for tags is a bore and useless thing to work with. I created a file for you or someone make some sense with. Hope you can help on this.

Composers.zip

Edited November 19, 201015 yr by Guest

This is not a correct implementation of a join table. The basic idea is to have ONE join table storing ALL choices made - see the attached.

If you want to expand this idea further, i.e. not just countries but other types of data as well, I suggest you watch this video:

http://www.filemakermagazine.com/videos/data-tagging-classification-vs-organization.html

Composers2.zip