Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    4

    Unanswered: Creating Relationships and Forms

    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.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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