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?
double dropdown
Re: double dropdown
naturick wrote: ↑2018-08-03 18:07I 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?
Re: double dropdown
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.
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.
Re: double dropdown
EUREKA!
It works fine!
Thank you very much
It works fine!
Thank you very much