Show Records basis a Field Value
Posted: 2018-05-30 07:39
Hi,
I have 2 questions:
Question 1
We have dealers from 6-7 countries... When the dealers open the system from their login, I was them to see records belonging to their country only-
I have a company_tb and a company_contact_tb and the both have a field named Country.
Question 2
I have a tables called Purchases and in that i have a field company... in the company field dropdown I want to show data, where the User Category (another table) User_Id = 'Supplier' and also in another I want to show all company records where the user category is NOT suppliers.
How to solve these. Please help
I have 2 questions:
Question 1
We have dealers from 6-7 countries... When the dealers open the system from their login, I was them to see records belonging to their country only-
I have a company_tb and a company_contact_tb and the both have a field named Country.
Question 2
I have a tables called Purchases and in that i have a field company... in the company field dropdown I want to show data, where the User Category (another table) User_Id = 'Supplier' and also in another I want to show all company records where the user category is NOT suppliers.
How to solve these. Please help