database set up

[AB]

Hello

I want to create a database to replace a currently handwritten form which is
completed by employees each day.

They enter - Their Name - Today's Date and the details of each client they
see

When entered I would like to be able to retrieve:
All clients for one day
All clients for one employee

I am hoping to set this up using a form for emplyees to complete

I'm used to setting up basic tables - my question is - how do I create as
form where the employee's name and todays date are linked and the records
for each client seen by that preson on that day are stored together?

any help gratefully received


AB

 

[Guest]

Have an employee table with a key field.

Create an Appointments table like--
Employee -
ApptDate - DateTime - default to =Now()
Client -

Set a relations from Employee table one-to-many Appointments.
Create main form for employee.
Create subform, datasheet, Master-Child links on employee.