AppGini Community Forums

Posted: **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?

Posted: **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?

Posted: **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.

Posted: **2018-08-04 19:35**

EUREKA!
It works fine!

Thank you very much

AppGini Community Forums

double dropdown

double dropdown

Re: double dropdown

Re: double dropdown

Re: double dropdown