Intermediate Relationships HELP!

[zoey_b]

I am creating a stock management system for my A Level Coursework and I am
completely stuck on one thing...
I have one table in which the user enters in the amount of stock used each
day and another which holds the stock levels for individual items, everytime
i try to link the two it says there is an intermediate relationship which
wont let me enforce referencial integrity and such.

How can i get the table of stock levels to be altered each time the user
enters in how much stock has been used?

Any pointers would be greatly appreciated!

Thanks!

 

[John W. Vinson]

I am creating a stock management system for my A Level Coursework and I am
completely stuck on one thing...
I have one table in which the user enters in the amount of stock used each
day and another which holds the stock levels for individual items, everytime
i try to link the two it says there is an intermediate relationship which
wont let me enforce referencial integrity and such.

How can i get the table of stock levels to be altered each time the user
enters in how much stock has been used?

Any pointers would be greatly appreciated!

Thanks!

In addition to Chris's suggestion, note that you will get an indeterminate
relationship if neither table has a unique Index on the joining field. What
are the Primary Keys of these two tables, and what field are you using for the
join in your query?