I can't see what the problem is but the field link designer wont give me the right options

company table :

        id: longint key field
        name : Alpha

person table :

        id : longint key field
        Company id : long int ( values match up to company:id)
        Name : Alpha

The field link designer only shows a join as possible between person:id and company:id instead
of person:company id  and company:id. It wont even display person:company id.

Person is the detail.  There are two datasources. The mastersource property is the company tables
datasource.

I've tried everything I can think of. I've never had this problem before.

The only other info : original table was dbase (above are paradox 5). The key fields were created,
originally, with auto-increment. As you may have guessed, I've split a flatfile for relational use. The split
is fine and the relationship seems valid to me.

Help please!

        Yours

                Greg

--

Hope that helps!

Rkr

The Person table MUST have an index by Company Id, otherwise it won't
work. Use the DBD to create a secondary index on Company Id.