Sort related records only

[redzwanlatif]

Hi . I have staff list records. It's divided into 2. Male and female.I'm using radio button for male and female choice. How can I sort only Male staff on the list?

 

Thanks in advance

[AHunter3]

You can GO TO just the male staff and then sort them.

 

Is that what you mean?

 

Or do you want the final result to be a mixture of male records (sorted) and female (not sorted)? (that would be do-able but it seems kind of weird)

 

 

To isolate the male recs only, either do a Find like so

 

Set Variable [$Gender; YourTable::RadioButtonField]

Enter Find Mode

Set Field [YourTable::Gender; $Gender]

Perform Find

 

 

... or set up relationship between the RadioButtonField and the Gender field and do this:

 

Go to Related Records [show only related, ThatRelationship]

 

 

either way, then you sort.

[redzwanlatif]

Thanks

 

I just want to sort the male records only. I tried your scripts. But it will sort both of them

[redzwanlatif]

How can I only list the male records ? The scripts are not working .

 

Thanks in advance

[AHunter3]

Please clarify: do you

 

a) want to LIST only the male records (the female records NOT BEING on the screen any more at this time) and sort the male records? or

 

b) somehow, in some unexplained fashion, end up with both male and female records on screen, but the male records sorted and the female records interspersed among them, somehow, NOT sorted

 

??

 

 

AND

 

please clarify also:

 

The scripts are not working

 

 

In what way are they "not working"? Are you getting male records but not sorted? Are you getting an error message? Are you getting male and female records sorted? Are you getting pink kitty cats and orange snails eating your computer screen? something else?

[redzwanlatif]

a) want to LIST only the male records (the female records NOT BEING on the screen any more at this time

 

Scripts:

Female records are there

[redzwanlatif]

 

Set Variable [$Gender; YourTable::RadioButtonField]

Enter Find Mode

Set Field [YourTable::Gender; $Gender]

Perform Find

 

 

 

I've used Set Variable [$Gender; "Male"] instead of Set Variable [$Gender; YourTable::RadioButtonField] and it's worked. Thanks for the answer.