0

Bulk Update - populating linked field

I need to upate 600 odd records with a record from a linked table. How can I update them all at once to be this specific record?

3 replies

null
    • Sean
    • 4 yrs ago
    • Reported - view

    When you say "update", do you mean you need to link them to a specific record? Do they have a common field?

    • SECOS Group
    • quartz_cap
    • 4 yrs ago
    • Reported - view

    Hi Sean, yes

     

    Previously I was using the "User" field to assign a staff member. I've since created a table to list staff members (as not all are users of the DB) so I need to populate the linked field to match the user.

    For example, I have interactions created by me (Sarah Chilby). I need to link all those records to the record in the staff table which is first name: Sarah surname: Chilby

    • Sean
    • 4 yrs ago
    • Reported - view

    Hi Sarah,

    If you have access to Webinar EN 2019, there is a database named LinkTables. Take a look at it and see if it helps you with linking your records. If you need help, post a follow up and I'll try to help.

Content aside

  • 4 yrs agoLast active
  • 3Replies
  • 1275Views