hi everyone,
i would like to ask if anyone able to guide me further on this?
i have created 2 different tables in supabase, for example
table 1 name as : SALE REPORT (Main)
table 2 name as : Sold Out ITEM (the table consider as Sub)
i have created the Column in supabase with id linked (int8)
>>>
as what i knew is whenever we need to linked both table together for each row, we have to manually click the item by select record
>>>
now i'm trying to figure out when at flutterflow, i created a button to insert data by uploading to 2 different table.
Record as below
1) purchase name : xx - upload to SALE REPORT (Main) 'S TABLE
2) purchased price : xx - upload to SALE REPORT (Main) 'S TABLE
3) purchase item : xx - upload to Sold Out ITEM'S TABLE
4) purchase volume : xx - upload to Sold Out ITEM'S TABLE
5) purchase ID : random string - upload to SALE REPORT (Main) 'S TABLE
How do i make sure once data uploaded, and it will be automatically linked this record into both table row.?
Kindly ask me more question if i did not explain well here. Thank you and appreciate.