circular key

[#1]

I need to present the profit margin per item, to link the purchase documents with the calendar does not offer true results, and to make script recharge occurs circular key the article and date code. Not as out of here, please need help.

I present the structure of tables

[nizamsha]

most of the time i will rename any one of the field  it will work u can try it and check the result.

[vikasmahajan]

This is due to some common fields in your data model , try to rename as per Mr.Nizmsha suggested  and additional you can joins tables fields as per your requirements to avoid common fields.

Vikas

[er_mohit]

use qualifier *; before table loaded

or you can use Qualifier A,B ; as wirte those fields which are common in both table

like

TestA:

load A,

B,

C from ......;

qualifier B,C;

TestB:

load A,

B,

C ,

D

from .......;

Doing this,it gives you primary link with A field name and remove the circular key

hope it helps

[#5]

Thanks for the replies.

These solutions and had in mind, the problem is that if I link sales or purchases with the calendar not take well to date, and if the articles I link to is exactly the same, do not pick the item up.

regards