E
Erika
Hi All,
I am sort of new to this, thus bear with me if my explanation to my problems
sounds confusing. Anyway, here it is:
1) I've created 2 tables ( Employees & Leaveinfo)
- In the employee table, I've got the details of the employees name,
datejoined & the employee id
- In the Leavinfo table, I've got information like empid, entitlement,
balance leave, type of leave and so forth.
I've managed to create a link between the 2 tables ( via the EmpID). I've
also created a form which record source is from the link tables.
Basically, what I would like to do is using the Employee table as a
reference ( no updates to this table is needed) I would like the user to
select their name and the date they last applied for leave accordingly and
with it retrieve the needed information from the Leaveinfo table. When the
user makes changes to the record, it should be saved as a new record not
overwrite the existing record i.e. the updates should only be to the Leavinfo
table.
I'm not sure if my structure of my tables are correct but conceptually I
know what I want but can't seem to get it right practically.
Appreciate the help.
I am sort of new to this, thus bear with me if my explanation to my problems
sounds confusing. Anyway, here it is:
1) I've created 2 tables ( Employees & Leaveinfo)
- In the employee table, I've got the details of the employees name,
datejoined & the employee id
- In the Leavinfo table, I've got information like empid, entitlement,
balance leave, type of leave and so forth.
I've managed to create a link between the 2 tables ( via the EmpID). I've
also created a form which record source is from the link tables.
Basically, what I would like to do is using the Employee table as a
reference ( no updates to this table is needed) I would like the user to
select their name and the date they last applied for leave accordingly and
with it retrieve the needed information from the Leaveinfo table. When the
user makes changes to the record, it should be saved as a new record not
overwrite the existing record i.e. the updates should only be to the Leavinfo
table.
I'm not sure if my structure of my tables are correct but conceptually I
know what I want but can't seem to get it right practically.
Appreciate the help.