Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please look at the attached snapshot, I need Phys_Name in Doctors Table also.
not sure I understand: do you need Phys_name on that table instead of the other one, or do you need to be able to slice data in both tables by that same field? If it's the first, then it should be dead easy using either APPLYMAP or a simple JOIN. If it's the latter, you need a link table in the middle which has the key and the shared attribute.
Hi,
Add this script:
JOIN (Doctors)
LOAD DISTINCT
DoctorKey,
phys_name
RESIDENT [ACP Detail Charges];
Regards,
Ricardo