
Hi Team,
i have 2 source of data(SQL Source)
1st source
| TableA | |
| StockName | |
| TataMotors | |
| Infosys | |
| Relience | |
| IndianOil | |
| ITC | |
| TATaSteel |
| Table B | |||
| StockName | ExternalValue | InternalValue | Date |
| TataMotors | 204 | null | 11/1/2022 |
| Infosys | 230 | null | 11/1/2022 |
| Relience | 450 | null | 11/1/2022 |
Requirment;- i have created a form with TableB as a Data source
and above the form i have one combox filter From the TableA
once user selects any field from the combo box then he can change the internal value and after hitting the submit button it should updted that perticuler row in the SQL Database but i am not able to see update option in the Card so how it will update the record and 2nd synario is when there is no any data in table B against the selected field from the comobox then it should add as entry in SQL database(TableB)
Thanks
Not sure if I understand it fully but the update box usually show only if you use a form.