Problem on relationship between 2 table

[cwwaicw311]

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 cant even do a query as they do not return any data even i have a few record in my table.

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

[ADezii]

Just subscribing, will have a look at the DB later. OOPs sorry, I do not have Access 2007, can you convert it to Access 2003 then Upload again?

[mshmyob]

cwwaicw311 you should not start a new thread when you have asked a question about your design in another thread and someone was kind enough to help you.

Just to point out you are still far from being normalised (as per your other thread of the same issue) - but since you don't seem to care about that I will tell you what is wrong with this issue.

You have 2 things wrong with your operator ID combo box.

1st - it is not bound to a field in your inventory table (therefore your selection cannot be saved to your inventory table)

2nd - your datasource is a value list rather than a query to your operator table (So in essence your operator table is not being used.)

cheers,

[ADezii]

Sorry mshmyob, didn't realize that this was a Parallel Thread already addressed. I just hope I'm not the one who addressed it! (LOL).

[cwwaicw311]

Hi,

Thank for the answer. I have been trying to normalize but just cant seem to able to normalized it. I hope u would tell me how i can normalize it.