By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,868 Members | 694 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,868 IT Pros & Developers. It's quick & easy.

Problem on relationship between 2 table

P: 4

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...
Attached Files
File Type: zip New Inventory Tracking (96.2 KB, 46 views)
Mar 15 '10 #1
Share this Question
Share on Google+
4 Replies

Expert 5K+
P: 8,745
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?
Mar 15 '10 #2

Expert 100+
P: 904
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.)

Mar 15 '10 #3

Expert 5K+
P: 8,745
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).
Mar 15 '10 #4

P: 4

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.
Mar 16 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.