I want to accept Duplicate Values in my table

[Nithin]

I made a table (Inventory) that consists of Barcode, Name and MRP. Some times the barcode remains the same only the MRP/Name changes. I gave like 2-3 data’s with same barcode, name but different MRP. In the Form Entry I referenced the column Barcode to that table(Inventory → Barcode). I want the duplicate barcodes to display in that referenced column as well as the table.

[Aurelien]

Hi @Nithin

Welcome to the community !

If you want to scan the items with their barcode ==> barcode column must be the key-column of the Item table.
But, key-columns must be unique.

==> what you are willing to do is not possible.

If you don’t care about scanning ==> you may want to create another column, like “ID” and with initial value UNIQUEID() (show option : OFF), and set this one as key-column.
Then, set the barcode column/MRP column/whatever-you-want-column with Label property ON

[Nithin]

Thank your for your Solution. I will try that