
why wont this master/detail relationship work?
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
--
Greg Lorriman co. inc. & sons Ltd