Skip to main content

Multiple Unique Record ID's

Comments

3 comments

  • Permanently deleted user
    Derrick Kotlus commented  ·  July 11, 2014 10:46 AM  ·  

    Hi John,

    This is a great question and a fundamental difference between our classic and new products. TrackVia Express/Pro do not have a system generated ID that is unique to each record. This is essentially replaced by the Record ID. When linking tables, it is this Record ID that you will use to identify each record in the parent table.

    You will also use this Record ID to import data into your table (if doing an import to update). You will need to ensure that all fields that make up your Record ID are included in the file you are importing.

    Hope this helps to clarify things a bit, let us know if you have any other questions.

    Derrick

    0
  • Permanently deleted user
    John McGarvey commented  ·  July 11, 2014 10:59 AM  ·  

    Thanks Derrick,
    This may exist, I just haven't made it far enough to create real LTP fields yet.

    From an end-user perspective, if I'm creating a child record and linking to a parent table, does TV-Pro allow the display of other fields (more descriptive) in the lookup search box in additional to the parent table's Record ID?

    If I am linking to my Employee table which has the Employee ID number as the unique Record ID (so we can import from HR data files), doing a parent lookup will be very difficult if all I am presented with is 25,000 ID numbers, but no names.

    Will the lookup display the Record ID + Another specified field (like the name), if so configured?

    Thanks

    0
  • Permanently deleted user
    Derrick Kotlus commented  ·  July 11, 2014 12:00 PM  ·  

    Hi John,

    The Record ID can be configured to include more than one field. This means that you can use the Employee ID and the Employee Name. As you stated, this is very beneficial when linking child records. However, if you would like to import to update using just the Employee ID and not the name, you will need to temporarily change the Record ID to exclude the name portion. After the upload is complete, you can change the Record ID back to include the Employee Name.

    Regards,

    Derrick

    0

Please sign in to leave a comment.

Powered by Zendesk