dbase! me too. long time ago.

dr. cod's rules for normal databases still apply...
however, depending on what you want to do, access eventually stops being easy.
there is lots you can do...

is this forms-based, that is, does each user update tables through forms? or does the user simply open a table?

is this a relational database? are the tables linked by foreign keys? or is this...

write a query and base the form on that query.
in one of the query's columns use something like this to limit the results: (this is the sql view)
WHERE (((PL.Store)=[forms]![frmtest]![cmbstore]))...

which program? ms access?

you can put a button beside the drop-down thingy that says something like [update users]
this opens a form that allows you to add to the table. the [save] button you create will save the row and...

if you've created tables in access, and you've spent time creating queries and based the forms on those queries... you can still use sql server.
on the server that is running ms sql server, create a...