how can i get users

[Anonymous]

I have user table

id	username	country	state
1	Anil	IN	AP
2	varma	AE	-
3	user	IN	Tl

and country table

id	country_code	country_name
1	IN	India
2	AE	United Arab Emirates

i have created a list box object using  country_name field, when i am click on country name, i need to display respective country users

Can u please tell me

[anvalo00]

Hola,

Tan sólo has de tener unidas las dos tablas con el campo país (llamándose igual en ambas).

Saludos,

[passionate]

Hi,

You can use this in test box:

=Concat({<country={'IN'}>}username,',')

Regards,

Pankaj

[effinty2112 · Accepted solution]

Hi Anil,

              In you country table drop the field 'id' and rename the field country_code to country.

country	country_name
IN	India
AE	United Arab Emirates

Now the data model will have the association between the tables you need. Associations are automatically made between fields with the same name.

Regards

Andrew

[Anonymous]

Thank you Andrew, it's working

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .