Link table for a common date field from two unrelated tables is creating circular reference

[Heena]

I have a data model, as below

i need the date field from Bug and Run table so i created a link table as below:

linktable:
load
date(B_DATE) as linkdate,
Bug_linkflag
resident BUG;

concatenate(linktable)
load
date(R_DATE) as linkdate,
Run_linkflag
resident RUN;

Note: RUN and BUG do not have any common field are not connected as well, so i have created separate flags.

'Bug' as Bug_linkflag, in BUG table and  'Run' as Run_linkflag, in RUN table.

The linktable is creating a circular reference as below:

How to resolve this? i need  date field from both RUN & BUG

[Gysbert_Wassenaar]

What you have in your data model is a loop. That means that there's at least one table that can be reached by two different paths. One of those paths needs to be removed. The screenshot of your data model is in-legible, but it's the bottom table in that image that seem to be the problem. You'll have to rename one or more fields in that table to break the link to one of the two other tables it's linked to.