double dropdown

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
User avatar
naturick
Veteran Member
Posts: 39
Joined: 2014-07-07 18:47
Location: Cluj-Napoca
Contact:

double dropdown

Post by naturick » 2018-08-03 18:07

I have these table:

Shop
Company
Owner
Company/Shop (store relation Company-Shop) with look-up fields Shop and Company
Owner/Company (store relation OWner-Company) with look-up fields Company and Owner

Now I have another table with some notes.

In this table my goal is to choose a Shop, then choose Company from filtered list based on Company/Shop and then Owner from a filtered list based on Owner/Company

Shop: OK
Company: OK
Owner: I see ALL the record....not filtered.

In Appgini app, I see the filter option on the Company look-up field, but nothing on Owner.....

Do you have any suggestion?

User avatar
naturick
Veteran Member
Posts: 39
Joined: 2014-07-07 18:47
Location: Cluj-Napoca
Contact:

Re: double dropdown

Post by naturick » 2018-08-04 07:49

naturick wrote:
2018-08-03 18:07
I have these TABLES:

- Shop
- Company
- Owner
- Company/Shop (store relation Company-Shop) with look-up fields Shop and Company
- Owner/Company (store relation OWner-Company) with look-up fields Company and Owner

Now I have another table with some notes.

In this table my goal is to choose a Shop, then choose Company from filtered list based on Company/Shop and then Owner from a filtered list based on Owner/Company

Shop: OK
Company: OK
Owner: I see ALL the record....not filtered.

In Appgini app, I see the filter option on the Company look-up field, but nothing on Owner.....

Do you have any suggestion?

pböttcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: double dropdown

Post by pböttcher » 2018-08-04 18:44

Hi,

I think you need to put the Company as the first selectable item, then based on the Company you can set the Shop as lookup from the CompanyShop with an filter on the Company. Next you can set the Owner as a lookup from the OwnerCompany table, again with a filter on the company.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

User avatar
naturick
Veteran Member
Posts: 39
Joined: 2014-07-07 18:47
Location: Cluj-Napoca
Contact:

Re: double dropdown

Post by naturick » 2018-08-04 19:35

EUREKA!
It works fine!

Thank you very much

Post Reply