----
I have 3 tables, Doctors, Allowances and Consulancy. All of them link by doctorID.

I have a data grouping for doctors.doctorID , 2 detail bands - target alias for detail band 1 = "allowances", target alias for detail band 2 = "consultancy". Am I do it correctly?

However, I get error "allowances" is not related to current workarea.
Any ideas?
---

John, this error message (and the reasons for it) is covered in the Multi-D minidoc in your release notes. Look for the section headed ("What happens at runtime?").

Briefly, if you have target aliases correctly defined and you have no SET SKIPs, the engine will dynamically SET SKIP for you on the theory that this is what you are trying to do.

** HOWEVER ** "correctly defined" means that you have defined target aliases that are related to the "driving alias" (current work area during the report run). The Engine will not attempt to set relations for you.

IOW... You say that "All of them link by doctorID." but you haven't indicated whether you've told the Engine this <g>. You probably need to set order and relation, if you're opening the tables manually, or set the appropriate properties, if you're using the DataEnvironment.

HTH,

>L<