Hi all. What table stores the last name and first name fields on the rd30 record? I did not find it in the webuser table. Thanks in advance.

I believe the table you're looking for is called LOMXVALUE

where the MATRIX-TYPE = PRIMARY and the MATRIX-CAT = NAME-LAST or NAME-FIRST

Thanks Rezaei. I did find that table but I was hoping that there were separate fields for Last Name and First Name, instead of having both user the same field.

They are separate fields.

First Name = MX-VALUE
Where MATRIX-TYPE = 'PRIMARY' and MATRIX-CAT = 'NAME-FIRST'

Last Name = MX-VALUE
Where MATRIX-TYPE = 'PRIMARY' and MATRIX-CAT = 'NAME-LAST'

I have the table Lo_mxvalue linked in MS Access and a person's last and first name are records under field Mx_value. What I am trying to accomplish is do a match of Lawson users against our termination file to automate our termination process. The termination file has a last name field and a first name field.

Since you're using MS Access you'll have to do what my boss does -- he takes Lawson data into Access, then "normalizes" it. In other words, you'll have to create your own table in Access with the fields in the "proper" form, then load the data in from Lawson in the non-normalized form. Once you have the data looking like it should, comparing it will be easy.

Thanks Milo - I was trying to avoid going that route but will have to.