Results 1 to 2 of 2
  1. #1
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130

    Can't get it to work..

    I had a form that would like you select an employee that you are trying to assign a port to with a combo box. There was a second combo box that would let you select the IT closet port that they would be assigned to. Then you click save and it adds it to the database. Here is the set up.



    I have tbl1Employees - Houses all employee information
    I have tbl1PortSlots - Houses all the port information in the IT closet.
    I have tbl3PortSlotAssignments - has a relationship between the two above tables where it is the middleman and can give you free range to input the employeeID and the portslotID and have it shown when queried.

    I want a form to where you can do this instead of manual entry on the table.

  2. #2
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    Was over thinking the issue. Just created a form from the tbl3PortSlotAssignments and got it to work.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 12-06-2014, 08:49 PM
  2. Code Does not work
    By larabeelw in forum Access
    Replies: 11
    Last Post: 11-27-2013, 03:18 PM
  3. Can't get 'Between' to work for dates!
    By Dynamo418 in forum Queries
    Replies: 6
    Last Post: 10-11-2013, 01:38 PM
  4. can't we just work together?
    By ldodge in forum Queries
    Replies: 4
    Last Post: 10-15-2011, 06:42 AM
  5. how does mdw work?
    By raffie77 in forum Security
    Replies: 2
    Last Post: 08-17-2011, 12:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums