FMP7

struggling to get this to work


In the same file I have two tables, my contacts DB and a control DB.
The Control DB stores, per user, various settings to be applied to the
Contacts Db. What I do is this:

Open Contacts DB
Open Control DB
Step throgh Control DB until I find the record I want
Set the window geometry of the Contacts DB widdow based on data read
from Control DB

But it doesn't work.
I can tell that the data used to set my window geometry is taken from
the FIRST record of control DB. But I can still see Control DB's
window, aand it is still positioned where I expected it to be. So it
looks like I am referringg to the wrong insstance off Control DB. If I
bring the Control DB wwindow to the foreground I DO get the correct
data. But I can't beelievee I have to keep selecting that window every
time I wwant ot get some data out of it - surely not??????????

There must be some way of referring to Control DB that, once I have
foundd the record I am interested in, will retreivee the data from that
ecord without me havingg to keep selecting tht winddow.

I didn't say, the layout is set to show records from Contacts DB. The
relationsship between the two is based on maatching aa global field that
is set to "1" in both DBs.


I am really, really struggling with this and would be VERY grateful for
some help!

thanks