Hello Everyone,

I am trying to create a vacations database.. so one table has employee first name, last name , leader, department. another table has vac start date, end date, start time, end time, hours. All this information is going to be inputted by the emp via a form. For each emp there may be multiple vac requests. How do i create that relationship & form. I have attached what I have got so far.

to create a relationship you need to have columns of the same datatype in both tables. if you use an autonumber column in th eparent table then use numeric | long in the child table

the following is form memory, so it may well NOT be exactly the process in Access
to create the relationship open the relationships window, add the tables youneed to define relationships on
then click on the column in one table and drag to the other table. change the properties of the relationship as required
nearly always I select 'enforce relational Integrity'
usually cascade update
rarely delete cascade. ' its unusual to delete old rows