>Hi Everyone.
>
>I'm in the middle of inventory control process module.
>When order is saved, it deduct ordered quantity from product database and
>it popup message when it is below order level.
>But I'm facing a problem because of supplier ship in.
>I've created inventory and invent_line_items which is hooked to the product database
>but somehow in inventory form, it won't let me have connection between product.product_id
>and invent_line_items.product_id. I thought the problem was because product.product_id
>was primary index and it didn't like to share the index with two table, so
>I've tried setting product.product_id to candidate and therefore created one more
>index called product.invent_id and make it so it identifies each record, but this method
>didn't let me form relationships between other databse(table).
>As to my understanding, primary keys forms relationships between multiple files and
>serve as lookup values in a referenced table and the unique indexing was used in
>previous versions of FoxPro V and now, this function is onqueries or views function.
>
>My question is, how can I hook invent_line_items.proudct_id with product.product_id at
>the inventory form, when the product.product_id is already hooked with
>order_line_items.product_id.
>Well, somehow it won't let me have this two field connect automatically nor manually.
>Can anyone help me??
There is something wrong here. You can "hook" a primary key with multipl tables. See home()+"samples\data\testdata.dbc" for example. Primary key (and/or canditate) has nothing to do with the former unique index. It's, in simple, there for persistent relationships at dbc level. You can however still set other type of relations in your forms (view is preferred though).

use table1 in 0 order tag product_id
use table2 in 0 order tag product_id
use table3 in 0
set relation to product_id into table1, ;
   product_id into table2 ;
   in "Table3"

Cetin