Hi,

I doin a small inventory tracking system and I have created 2 table. Inventory Table store the Inventory ID(PK), date, receiveQty, issueQty, OperatorID(FK) and Operator table store OperatorID(PK) and shift.

I have a form whereby user input all the necessary data such as mention above.

After saving a new record, the Operator ID which located in the Inventory Table as a foreign key does not show the value although the value is available at the OperatorID in the Operator table.



I have attach my database if it can make you clearer and also help me to solve this problem. Thank...