Can I have a single-field table?

NeAlvey

New member
Local time
Yesterday, 21:34
Joined
Oct 21, 2005
Messages
9
Hi all. I'm working on a temporary database (Access 2003) for work until we get our system validated. Is it okay or acceptable to have a single-field table or do I need to throw an autonumber on there for the key? I really just need this table to populate a combobox/listbox in the form. I don't want to to use the "OnNotinList" with the combobox so I need to store them somewhere. Thanks!
 
A O K

Though it is not recognized as good practice to create tables without a unique identifier, your table is simply a list for a combo box and so no real data relationship is being created. one field is perfectly fine.
 

Users who are viewing this thread

Back
Top Bottom