Using Access 2010, I am looking for a simple, built-in feature to store multiple values (unpredictable) within a single field per record.
As an example, Record_ID #100 has a field called VALUE_FIELD. The form currenlty shows a single field called 'Value Field' to the end user. The user can enter a single value. Well, I just discovered that the user must enter multiple values per record, so each value can be searched independently. The values will look like A123456, A78910, C78236, B12645. This cannot be a multiple value lookup field because the values changes everyday and are generated by another system. Is there feature built into Access 2010 to set this up?
I am a novice Access developer and prefer NOT to use custom VBA. Thanks in advance.