Specific form

[pm4698]

Hello there,

I am new in access and i try stuff.
I have created a table. One field of the table is called lastname.

I want to create a form like a table, where the first column will be the lastnames and the rest columns will be blank but in combo box style. Each of these columns will have a day as a label.

As a conclusion, in each row i will have a name and i will choose at each day a choice from the combo box.
How can i import some kind of diary per month?
Choose month and then to show the days of that month but automatically without need to design a new table for the new month?

 

[YNWA]

What will be in the drop down menu?

Set the form in datasheet view, have one field linked to your surname field in table and then add dropdowns in, how many dropdowns per row will yo uneed?

 

[pm4698]

In the drop down there will be values from another table. For example the choices of each drop down will be:
waitress
barwoman
cleaner

And i want the other columns (except the surname column) to have labels the days of each month we are into. So, i want for each surname to check if Monday for example he/she was barman or cleaner. The next day he/she will be waitor.

So, at the end, i can see what day each employee worked and what did he/she do

 

[YNWA]

I would have a tables with the following fields...

employeetbl
fields = employeeID (PK), surname, firstname

diarytbl

ID, employeeID, jobID, date, DayofWeek

jobtbl

fields = ID, jobDescription

Daytbl

fields = ID, Day

In your form have an employeesection with emploeetbl fields.

Then have a subform called diary, which would include your diary fields, your dropdowns would be in here with job and day of week. Set this to datasheet view and it will look like a table and be easy to view and use.

Each entry would enter a date and record the drop downs as needed.

Thats sort of how I would do it, not sure if its 100% the right way though./