Originally Posted by
aytee111
Looking good! Still that one field missing, lol. OK, I'll give you a clue, it is on the Items table.
In table design, as you click on each field, the properties are shown beneath. These need to be filled in for each and every field. You need to know exactly WHAT the field is going to contain, all the possible values, and make sure the field is defined just for that; also exactly HOW the field is going to be used.
Don't touch anything that has to do with the visual display of the field, such as formatting, lookups, etc. or things that will be handled during form entry. Your responsibility is data, to ensure that the table holds the right data at the right time and that nothing can be stored that disobeys your requirements.