Hi @Robert_Petitto
I have a product list table and business owners table.
I will create business owners table manually has columns like,name, email, phone number, shop name and address.
Shop name is unique
Product list table has product sku, description, category, category type,shop name, price etc.,
What needs to achieve is,
Suppose I fill the details of business owners in business owners table,it should show only the products of this particular business owners products only n he can add ,edit n delete if he wants.
Can you put one video based on this.
Jack has created a few nice explanations and videos that should help you. Have a look at the bottom of the relations page, there should be a video called “Things in things”.
Sound like all you need is a multiple relation from the business to a “business id” (could be rowID of business) to the products table. Then display an inline list of that relation.
1 Like
Hi Robert,
I have posted some screenshot for you.Have created the relation and its getting the products but its not showing in the list of tables.
The image below is showing all the products from the productlist table but i need if abc@gmail.com enters it should show products related to this email.
The below image shows i gave 2 email id so it show only one product for each email id.
Now i manually gave the filter condition as shop name is Params,it showing product related to Params which is a shop name.
The below is the product list table
The below is the business owners table
what should i do for to achieve,if the business owners enters with the email logged in to the app,it should show only their products and are allowed to add,delete and update products.
Also when the business owner creates new products it should autofill email and phone number,where should use set column values.
You could just add row owners to the email column.
Row owners in business owners table?
In the products table where the email column is located.
It raises another question,
I’m creating the business owners table manually entering details of business owners.
When this business owners create products the email column ishould auto fill the email column from the business owners table.
Am I going in the right way?
