Quote Originally Posted by szlamany
Right now I'm trying to get Simply Me to understand that a "Sequence Number" field added to the table - and made part of the compound primary key - can offer a unique PK when more then one entry is done for a single date.
I guess Im already aware of it that I need to add the Sequence number field. My question is-- is this something that the user will input or it should be an autonumber field?

Kindly please take a look my code. I know that the function below does not let me have more than one entry of the same product. when I removed the code i am still not able to add products since my productID needs unique value.

Kindly please take a look at my code above. What should it look like?
Code:
'TODO : return true if ProductID already exist
Private Function Checker() As Boolean
  Checker = False

  If rsTempStock.State = adStateOpen Then rsTempStock.Close
  sSQL1 = "SELECT COUNT(ProductID) as ProductIDExist " & _
         "FROM tblStockMasterFile " & _
         "WHERE ProductID = '" & (txtProdID.Text) & "'"
  'Debug.Print sSQL1
  rsTempStock.Open sSQL1, oConn, adOpenKeyset, adLockReadOnly

  If rsTempStock("ProductIDExist") > 0 Then Checker = True
End Function  'Function Checker