Tagging a record

[Coriolan_66]

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

[Coriolan_66]

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)

[Lee Smith]

Have you use Checkboxs for the Nationalities?

[Coriolan_66]

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.

[Coriolan_66]

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+

[comment]

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/

[Coriolan_66]

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, 2010 by Guest

[comment]

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