Drop down controls next drop down

[ThePhysio]

Drop down menu 1 display all results from table X row A.

I want drop down menu 2 to display table X row B where row A matches the selected value of drop down menu 1.

I also want drop down menu 3 to display table X row C where row B matches the selected value of drop down menu 2.

How is that done?

[Genx]

Have a look at this.

[ThePhysio]

Thanks!

But im too new at this. Rigth now I miss SQL...

im using tables.

- ICF full

- ICF subset

- Anames.

I want ICF subset to display values from ICF full, and Anamnes to display values from ICF subset.

It seemes to me as i have done what is decribed in the othe thread. What have i done wrong?

I attach the file and hope I learn something.

SgNet.fp7.zip

[Genx]

Okay,

I'm having a bit of trouble pulling apart your file because it's hard for me to try and work out the (german?) but it looks to me that you are relating TOOO many fields at the moment.

Could you try explain what the actual table's store so i can try work out what your trying to achieve that way?

Cheers,

~Genx

[ThePhysio]

It's Swedish (The language of honour and heroes as they say in Finland...)

ICF stands for "International classifiction of function"

ICF full contains all 1461 records.

Its arranged hierarcically in.

Category (= kategori)

Chapter (=kapitel)

Domain (=Domän)

Component (=komponent)

I want the users to make mangeable subsets and then use them in the patients journal (≈ Anamnes).

Different proffessions need different subsets.

Whan the user makes a subset i want them to select Category and then only see th chapters in that category, when you select chapers you should only get the domains from that chapter e.t.c.

I want the same thing to happend in Anames.

And thanks a lot for your help!

[Genx]

I'm sorry, i'm a bit ignorant....

Anyway, from looking at the values, it doesnt seem that you should be relating the Komponent values because none of them look to be unique.

But now that i realize that (i think) we're talking about the ICF my subset layout. Do you want each of the five lists there to be conditional?

I.e. Category Filters options for Chapter

Chapter and Category Filter options for Domain

Chapter and Category And domain filter options for component... and then all four values together give you Signature?

[Genx]

It's all good... i worked it out i think.

See attached. I destroyed some of your relationships temporarily so i could isolate the value lists.

~Genx

SgNet.zip

[ThePhysio]

You almost got it rigth.

It's the "My subset" we are talking about.

And you understand almost what i want to do with the filtering.

I just want to enter all the filtered values.

The signature is a another question.

Thats the owner of the subset, (and it would be really nice to get the username for the database there... )

If you need, i have made a quick translation of the tables.

EngSgNet.fp7.zip

[Genx]

to get the user name just use Get(username) - this will return the current person logged in, you can use it as an auto enter value. Take a look at the sample, and then if i didn't get it right give me a yell and i'll have a look at the english translation.

EDIT: Sorry, Get(AccountName)

[ThePhysio]

Thanks...

Now it's done but i still dont understand.

I'll just have to think about this for a while to see if I understand how you did.

Why is the browse view different from the layout view?

[Genx]

Sorry, it's in table mode, go into layout mode, choose the layout menu, layout settings, view and choose to allow table and list. I only disabled them because it was easier to make sense of everything that way.

Make sure you look at the value lists.

But lets just take one value... Domain

Given that we have a particular chapter and a particular category, we only have a select number of Domain's.

~Genx