FormsSubForms

  • Thread starter Thread starter SusanM
  • Start date Start date
S

SusanM

Have 1,000 employees, who on a yearly basis receive grants
of paid and unpaid time.The simple employee form with all
job info works great. Trying to create a form to enter
granted time with some employee info. Primary key would be
employee ID #. Am I going about this in the wrong way?
Form and subform? Another issue is the grant year. There
should be a parameter query asking what year. I am sorry I
have asked to much but I have looked at this so many ways
I am lost. Suggestions please. I appreciate very much your
help and advice. Also, I know this hurts, but I am not
familiar with VB.
Thank you all
 
I think that you should have a Form-Subform system for ease of entering
and viewing the data. Main form should be based on Employee data (table
or query selecting relevant information, including EmployeeID, the
primary key from the Employees table).
I think you want also to set up GrantTypes table:
GrantTypeID (autonumber)
GrantTypeDesc (Paid time; Unpaid time; Bonus time; Greviance time etc.)
The subform should be based on a separate junction table, which needs to
have the following fields:
EmployeeID
GrantTypeID
GrantAmount (if applicable)
GrantYear
You could use an Autonumber PK in this table, or a composite key if,
say, same type of grant can not be issued to the same employee in the
same year.
In the subform, use EmployeeID to set up the Parent-Child link with the
main form. Make a combo box with 2 columns, first hidden, based on
GrantTypeID and GrantDesc. Make GrantYear a combo box with the row
source in the form of a list of years (or make a table of years if you
have too many years).
You don't need a parameter query to enter grant information. You may
want it later to pull up grant information for certain year.
This is it!
Good luck,
Pavel
 
Back
Top