category problem

[d²c]

Hi there,

Thanks in advance to take a look at my problem

I want to create a tabel called ARTICLES. Every article in the database must be categorized by three levels.

For example

Category1

Category2

Category3

If the article is added to the database, it goes like this:

Category1: Wood

Category2: Birch

Category3: Plate

Article name: art01

I want to make the database relate to the three categories, so that the user can select category1, in the example wood. If he selects category2 he should see only the subcategories of wood, not for lets say iron articles.

I know I need three tables for the categories, and relate them to each other, but how?

After this, in the article table should be the total line of the article, including all categories. this so I can easily work with my articles table to make the output.

Is this all possible? And more important, how??

I've included a file with the basic tables, maybe someone can show me how to relate them?

Thanks for your help.

Regards,

D

articles.zip

[Razumovsky]

Hi D,

Run a search for "Conditional Value List", this is what you are looking for I think, and there is a wealth of posts and examples about them on the forum.

Here is one to get you started.

-Raz

[Søren Dyhr]

I know I need three tables for the categories, and relate them to each other, but how?

I'm not sure - linking on actual field values is a little iffy think of typos, I would say one single or two tables...

http://www.nightwing.com.au/FileMaker/demos8/PortalFoundSet.zip

--sd