Ok, the other day I asked a question regarding setting up a Time Clock in Excel. A suggestion was recommending I instead use an Access database. So I gave it a whirl. (As I originally indicated I know little about Access Programming, so I apologize in advance for my stupidity but I am trying to learn and understand).
Anyway, I downloaded from MS the "Time Card" template database and used that as my jumping off point.
In that database was a table named "Employees
" and a query named "Employees - Extended
". I added a table called "DBA Locations"
Since a Company could own more than one Location. I have attempted, and I believe it worked, linked via Lookup wizard the tables "Company
" and "DBA Locations
". That seems to work.
I then went to the Form "Employee Details
" and am attempting to modify the template that was from MS. The template form opens and you have to key all the info details. However, in the record field "Company" it was defaulted as "text" and since an employee in this database can only be assigned to 1 (one) Company I wanted to get just a drop down list that whomever is keying in will just pick the Company Name.
The form only shows the table "Company
" ID # not the name of the Company. The drop down list should show a list of names (not the ambiguous ID#) that the operator just picks from. (This is step one since the next step will be once they've picked the Company the DBA Locations list should filter to only DBA names of that particular Company.
What am I missing?
I've attached the accdb
THANKS IN ADVANCE FOR ANY HELP! Time-Clock-Project.accdb