hi, I would like to know if I have table1 with those field ID, lastname,firstname, and want to create table2 with the same field and have a lookup in ID in table1 will automatic populate tha lastname and firstname on table2.Can I do that?
Boris, you don't need to have LastName and FirstName fields in the table2. It's enough to have the numeric field like PersonID there and use lookup wizard to fill it. table1 will be lookup table, Link field - ID field, Display field - Custom expression concat(FirstName,' ',LastName).
