Results 1 to 2 of 2

Thread: Database Help

  1. #1
    Join Date
    Oct 2011

    Unanswered: Database Help

    Hi Everyone
    I am very new to access so i need some help on how to create a form.. I am creating a vacation database that has two tables... Employees & Vacation
    Employee table contains: EmployeeID, FirstName, LastName, Leader , Dept
    Vacation table contains, VacId, EmployeeID, Start Date , End date, Hours,
    I am trying to create a form using these two tables and having a hard time. I want the users to be able to input all these fields, first / last / leader / dept / start date / end date / hours. but when i create the form with these fields it doesnt add anything to the tables. I have bound all the text fields to the appropriate table and I used the button wizard informing to add record when the submit button is pressed. not sure what i am doing wrong.

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    If you're trying to enter data for both Tables, using a single Form, the Form has to be based on a Query and the vast majority of Queries are Read-Only.

    Since employees will presumably have multiple vacations, over time, you're describing a One-to-Many relationship, and these are usually handled using a Main Form, for entering data for the Employees Table, and a Subform, for entering the data for the Vacation Table.

    The Main Form/Subform would be linked using the EmployeeID Field, and the data for each can now be saved to their respective Tables. As you move thru the Employee Records on the Main Form, the Subform will automatically move to the Vacation Records for that Employee.

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts