Skip to main content
Question

Lookup employee number from name

  • August 10, 2019
  • 0 replies
  • 31 views
not sure if this is a formula or a relationship but I'm looking to pick an employee's name and have the employee number of that person auto-populate. 
    This topic has been closed for replies.

    If you are storing the employee name and number in another table it is a relationship but if you are wanting QB to create the employee number it is a formula. 
    As per the above, you will need to have a table of employees and then have a relationship where 1 EE has many detail records. Then pull in the EE fields to the detail records on a lookup formula.

    Here is some help on Relationships.

    https://help.quickbase.com/user-assistance/about_relationships.html


    Terms & ConditionsAccessibility statement