Results 1 to 3 of 3
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    A change in tables

    In a previous post I merged two tables a tblBranchID and tblPersonnel. Now there is just one table, tblPersonnel. It contains everything that the original tblPersonnel contains, plus two new things a branch identification fileld and whether or not that person is or is not a branchhead. That make one table able to hold all of the personnel.

    It does change some things, however. For instance. I have a combo box on another form and its control source is a field on the Branchhead table. That table is no longer.

    I must change that combo box. But it is not enough to say are they in the tblPersonnel. of course they are. That worked very well when all of the brancheads had their separate table.. The question should be are the on the tblPersonneland and are they or are they not a branchhead.



    I will use the yes/no control, but I still must account for it in the combo box on said form.

    Is this correct and how do I change that combo box to reflect the change?

    Any help appreciated. Thanks in advance.


    Respectfully,

    Lou Reed

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Use an SQL statement in the RowSource and apply filter criteria.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    Hi Lou. I still recommend that you post your DB in the Database Design category and describe the processes you are trying to automate. Your table structures should have been mostly (ideally all if possible) completed before you began working on the UI.

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

Similar Threads

  1. Replies: 2
    Last Post: 03-27-2017, 05:02 PM
  2. Must Change the Path to Linked Tables
    By michaeltrombetta in forum Import/Export Data
    Replies: 3
    Last Post: 03-11-2016, 02:20 PM
  3. Replies: 3
    Last Post: 10-13-2015, 11:34 AM
  4. Replies: 2
    Last Post: 12-04-2013, 08:09 PM
  5. Replies: 14
    Last Post: 08-04-2010, 07:34 AM

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