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??