Connecting Tech Pros Worldwide Forums | Help | Site Map

Relations not visible

Jef De Rycke
Guest
 
Posts: n/a
#1: Nov 12 '05
Hi access group,

I have written code to create relations between tables according to a
corresponding relations information table.
At first I thought my code was not working properly because after running
the code the relations don't show in the relations window. However when I
enter data in an underlying table I get referential integrity error messages
so the relations does actually exist. The created relations do show in the
relations system table. Why is it showing in the relations system table and
not in the relations window?

Any help appreciated!

Thanks in advance,

Jef



Bas Cost Budde
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Relations not visible


Jef De Rycke wrote:
[color=blue]
> Hi access group,
>
> I have written code to create relations between tables according to a
> corresponding relations information table.
> At first I thought my code was not working properly because after running
> the code the relations don't show in the relations window. However when I
> enter data in an underlying table I get referential integrity error messages
> so the relations does actually exist. The created relations do show in the
> relations system table. Why is it showing in the relations system table and
> not in the relations window?
>
> Any help appreciated!
>
> Thanks in advance,
>
> Jef
>
>[/color]
Do they appear if you choose Display All Relationships? (that is a
button and a menu command) The window is just an interface, and by times
it behaves a little autonomous (=buggy).

I use the same approach, creating relationships from code by table data,
and it works perfectly.

--
Bas Cost Budde
http://www.heuveltop.nl/BasCB

Closed Thread