adding multiple entries in a datatable with the same primary key

Forum|Forum|6 years ago
February 11, 2020
14 replies
5135 views

I have a datatable with productname as primary key. i have two list widgets, one for product name and one for quantity. Now, for examples, if i select a product,say, a PCB and quantity as 2, then my datatable should make 2 entries having product name as PCB only. how do i do that?

Mashup-Widget

Best answer by raluca_edu

You should call Add service in the new service you are creating.

You can check also AddorUpdateDataTablesEntries (this is allowing you to add more than one entry in datatable).

Regards,

Raluca Edu

C

Constantine

18-Opal

Hello @gourinaik98,

If you use product name as primary key, you won't be able to insert two rows into your data table with the same product name. You should either insert one row with quantity = 2, or insert two rows, but use a combination of product name + quantity as your primary key.

/ Constantine