I’m working on small database describing when particular people has done particular things.
I have table
Dates that contains
Date. First two are primary key.
I’m looking for convenient way of putting data into this table. I’ve created form with two list fields and one data field, and it makes adding data easy, BUT if there already is record for particular
EventID combination, I need to find it manually using arrows and then edit. I hoped that setting
EventID as primary key will require me to only choose these two fields correctly from list and then new record will be added OR old one will be updated, but I was wrong.
I think that it’s quite common task, but I cannot find any solution. I’m not sure if I should learn writing macros, or maybe there is easier way of doing it using sql or something. Any help will be appreciated, thanks in advance,