Need help with 2 tables (Relational )

I have a program that imports information from another database. Here
is the problem.

Table 1 I have a field called Sys_Id. Autonumber Key

Table 2, I have a field called Something_ID

When I import into table 1 (Sys_ID) I need to also have table 2
(Something_ID)populated with the same info and have a relations ship
with both tables. In the Clarion examples it maual entry works fine
and I understand that. But when importing info from another database,
I dont get the same results.

Any help would be appreciated.

Charlie

Hi Charlie,

After importing both databases into two tables, you could write a
batching process to loop through each entry of the first table with an
inner loop (or a single Get) of your second table with boolean search
criteria to match the first, pass your variables from first to second,
then write the results to disk before moving on to the next entry of
the first table. This is the idea you can apply to Legacy or ABC:

LOOP ! table 1

LOOP ! table 2

IF table 2 = table 1 boolean criteria
table2.field = table1.field
PUT table 2 ! write to table 2
CYCLE ! move on to next table 1 record
ELSE
! keep searching
END  ! end of criteria

END ! end of inner loop

END ! end of loop


cparvin@parvin.phxcoxmail.com (Charlie Parvin) wrote in message news:<9ed5bf67.0403200112.4
9979f87@posting.google.com>...
> I have a program that imports information from another database. Here
> is the problem.
>
> Table 1 I have a field called Sys_Id. Autonumber Key
>
> Table 2, I have a field called Something_ID
>
> When I import into table 1 (Sys_ID) I need to also have table 2
> (Something_ID)populated with the same info and have a relations ship
> with both tables. In the Clarion examples it maual entry works fine
> and I understand that. But when importing info from another database,
> I dont get the same results.
>
> Any help would be appreciated.
>
> Charlie