Need to replace field data 1

[Phillipg]

I have two tables that hold the data, one table holds the incedent data and the other holds the employees data. I have linked to two tables at the INCEDENT.DRIVERID to the EMPLOYEE.ID, and the INCEDENT.ATTENDEMT1ID to the EMPLOYEE.ID. what I would like to do is in the detail section is to show the EMPLOYEE.LASTNAME for the driver and for the attendent1 I have tried the replace function without any luck. any help is appreciated, thanks, Phillipg

 

[rosemaryl]

Dear Phillip,

If I understand your situation correctly, I think that you need to add the Employee table again (Alias it as Attend_Emp).

Once you linked from Incedent.Driver ID to the Employee table, you only get Employee information who are drivers.

So, in Database/Visual Linkin, click add tables, add your employee table again and link as follows:

Incedent Incedent Employee Attend_Employee
Driver ID ------Employee ID
ATTENDEMT1ID ----------------------------------Employee ID

I think that will solve your problem.

If you need more help, just ask.

Ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Phillipg]

Thanks Rosemary, this worked great.