Filtering two IBTable and insert or edit IBTable

[DeddyH]

This looks a little weird. Are you sure you navigate through both datasets simultaniously? Why not use SQL? Untested:

SQL-Code:

UPDATE
  ATTENDANT A
SET
  NAME = (
    SELECT 
      USERNAME
    FROM 
      USERS
    WHERE
      USERID = A.ID)

[danten]

Work, thanks
update attendant a set name = (select username from users where id = a.userid)