I created a form and just allow me to add new rows. The table has a two columns cocatenated key [Event Date] & [Site] . So when i select one value of the columns (25/07/2021 and Mokambo Bar), that was a previously added record row, the form does not display other columns data for Edition. And when you try to save, a message pops There is already a row with the key 25/07/2021 Mokambo Bar.
My question is why the form does not show the record previously added and allow to edit other column data.