[ic] table editor w/ linked table not copying foreign key

Paul Jordan interchange-users@icdevgroup.org
Fri May 16 20:18:01 2003


IC 4.9.7

Hi guys.
As you know, the table editor allows you to link to another table, for
inserting relevant records. Like a transactions is to it's orderlines.

A mod was made a while back to allow the number of blank rows that showed
up, to be set by the user. So, if you wanted 10 blanks rows to show up, when
editing or inserting a record, it would allow for fast table update, without
multiple form submits.

The AUTO NUMBERING of the key for the above scenario works fine (with
link_row_qual for go|no-go), but for some reason, the "copying over" of the
primary key to the foreign key does not happen automatically. I was under
the impression that this happens automatically. The table linking starts in
Vend/table/Editor.pm line 2818.

Does anybody have this working so to where via the table editor, the primary
key gets copied over to the 'link_key' column value?

I am at a loss when trying to figure it out myself. I mean, take this for
example:

line 2929:			my %o = (
					table => $lt,
					key => $_->[0],
					extra => $opt->{link_extra},
					pointer => $rcount,
					stacker => $tcount,
					columns => $lf,
					extra => $opt->{link_extra},
				);

Why is 'extra' in there twice? Just when I think I understand this stuff, I
find that kind of stuff!

If someone can give me a hint in the direction what I am looking for in
Editor.pm I would like to try more. I have tried off an on for the past few
months. If a consultant out there is familiar with this area, and knows it
is more than can be explained, feel free to send me a quote for it.

Thanks

Paul  paul@gishnetwork.com