I have a simple form for data entry.
ID: autonumber
Date: shortdate (textbox, yesterdays date by default)
AspectID: text (combo box from user table, 2 column with ID# and concated first and lastname, bound to column 1)
various other record entries
It all enters into table easily enough, but what I need to do is create the ID as Date+AspectID in the table so records aren't duplicated. There is only 1 entry per day of AspectID.
The ID doesn't need to be autonumber, just unique.
The user fills the form putting in the date and AspectID, I need that to stay the same.
ID: autonumber
Date: shortdate (textbox, yesterdays date by default)
AspectID: text (combo box from user table, 2 column with ID# and concated first and lastname, bound to column 1)
various other record entries
It all enters into table easily enough, but what I need to do is create the ID as Date+AspectID in the table so records aren't duplicated. There is only 1 entry per day of AspectID.
The ID doesn't need to be autonumber, just unique.
The user fills the form putting in the date and AspectID, I need that to stay the same.
