I am inputing information into a LO table on my Macbook. It is a list of camp staff, and general information. My husband and I are both on staff, so most of our information is the same (last name, address, phone number). It is now giving me an error message, and not letting me add anymore data into the table, due to a “violation of unique constraint”. I WANT the lines to be same…not to be “unique” but I cannot find a way around this. Is it possible?
This indicates that one of the fields is set as the Primary Key and therefore the data in that field must be unique. Or you have created an index of one or more fields which is unique. Trying to enter data in these fields which is already in another record will give the constraint violation.
Thank you! That helps a lot. I ended up starting over, and let the first row be the primary key, and it just says “index”. It actually did that the first time, but I deleted it thinking I didn’t need it. I wasn’t able to add it back in to the existing table, so that is why I started over. After I read your comment, I remembered deleting this row, so now I see why it was important. Thank you so much!!