Jump to content

Drop down controls next drop down


ThePhysio
 Share

This topic is 5652 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Newbies

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!

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5652 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.