Hey, so i am building an app where I can add all my coupons (structure is similar to notes app shown in the course)
To give an overview of the flow, a user inputs some data in a popop (It includes, coupon code, company name and expiry date)
For this I have created 2 tables as shown in the image below
What I want to do is, if company name is present in “All company list” table then it doesn’t create a new row in that table and just fills all fields in “All coupons” table. This includes company name and company sector.
If company name is not present in “All company list” table then it creates a new row in that table as well as fills all fields in “All coupons” table. This includes the company name and company sector.
I am unable to do so, it could maybe be because of the field type I have chosen (Also in screenshots below). Would highly appreciate your help on this