Search results

Hey guys not sure if im on the right section here but i will give it a go i have a table called EPOS_LAYOUT ID Short Text PK BUTTON NAME Short Text POS Short Text I have a form with command buttons on going from CMD_1 - CMD_40 I am wanting to open the form and ON OPEN i want the CMD_1 command...

Thanks for the quick reply. i have done that but when i run the query it then creates two records for each staff. any ideas as to why it would do that?

Hi can anyone help me Table [Staff_Details] Staff ID PK , Staff Name Table [Rota] Shift ID PK , Staff ID FK , Staff Name , Date, Time In, Time Out I am wanting on my form for me to select the date and click create and have the form create records and each record to have the Staff ID and the...

Thank you for your responce . Im sorry i dont think that would be the best way around it. I am NOT creating a time sheet that monitors the times that they have clocked in or out because your correct having a more simple form that creates the day and the time in and out for each day would be...

Not sure if im in the right section here but will give it a go. I am developing a Rota system that i want to be able to time manage my staff. I have a in and out for days monday - sunday and i want to be able to add the man hours that i have uploaded onto the system. I get it to work if i...