Hi

To resolve the circular reference problem, try creating an FB view with the fields you want to use in the lookup (and the primary key too).

Then use the db table for the Read-Write datasource, and the view for the lookup datasource. Be sure to set up KeyLinks, KeyDescLinks and KeySource for the 2nd datasource.

I tried this using two IB_Queries and an IB_LookupCombo. Hope this helps.

James N Hitz

----- Original Message -----
From: Bertin Kiekebosch
To: IBObjects@yahoogroups.com
Sent: Friday, May 19, 2006 10:29 PM
Subject: [IBO] Circular references


I have a table with a circular reference (A foreign key to itself to
create the relationship between two departments, one a subdepartment
from the other (parent)).
I use a TIBOTable to get the data. I connected a grid to enter the
data and it works. But now I want to add data controls to enter the
values. When a add a TDBLookuplistbox to enter the value for the
parent, I get a n error "circular datalinks are not allowed".

Even when I add an extra datasource and table for the lookup I still
get this message. Is there a way to enter the values of circular
references with DBControls.

Thanks









___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !



SPONSORED LINKS Inventory database software Database management software Oracle database software
Customer database software Database design software Database software


------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "IBObjects" on the web.

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


------------------------------------------------------------------------------




[Non-text portions of this message have been removed]