Creating Multiple Record

[channell]

I was curious to find out how to create multiple records for an employee. I
want to be able to select an employee and schedule vacations and multiple
days off from work.

Here is what my tables look like:

tblEmployee
Employee ID (PK)
NAME

tblDailyInfo
DailyInfo ID (PK)
WorkDate
TimeOffReason
....and so forth

Here is what I envision:

I select an employee from a combo box. Below that is another combo box with
a list of multiple reasons why someone would need time off. I select a
reason. I enter a start date and an end date for vacations. I need an "OK"
button at the bottom. Once I click it, it would created a record for every
day that person is on vacation or absent.

Thanks for your help in advance! if you need to email me, please do so at
(e-mail address removed). Thanks!

 

[Wayne-I-M]

Hi

Add the Employee ID to tblDailyInfo (number format)
Link the tables in the relationship window.

 

[channell]

I am sorry... I do have EmployeeID in tblDailyInfo. I am not sure where to
go from there. Thanks!

 

[Wayne-I-M]

Hi

Open the relationship window and drag the field from tblEmployee over the
the same field in tblDailyInfo and create the relationship. I would suggest
the you use integrety (so you can't have days off with no-one taking them ??)

Next create a query with both tables in the design grid (the relationship
will show here as well).
Drag the fields into the query that you want from the table then create your
form.

Next create a new
Next - open the form in design view and (use the wizard toolbox) add a a
combo to give you the items you want (base it on a query that the wizard will
create for you).

If you want to casscade the combo (so that when you select an employee only
they will show in the next) ensure you refer to the 1st combo in the query
the 2nd is based on (use the build option in the criteria row).

Hope this makes sence.