So, I hope that i'm just making a simple error, because as far as I know this should work!
I have two tables. (and i'll just simplify it because the other info isn't necessary to aide me!)
tblProduction
ProductionID - Autonumber - PK
ProductionLocation
tblStorage
StorageID - Autonumber - PK
StorageLocation
ProductionID
Now. I have two forms. One is frmProduction and the other is frmProduction_Stored.
A user inputs in the frmProduction form and then has a drop down that determines the "disposition" of the items produced.
Once that disposition is selected it will open up one of three forms(depending on the value selected), in this example it is frmProduction_Stored.
It then opens up that form and fills in tblStorage.ProductionID with tblProduction.ProducitonID. And then the user can fill out the rest of information required for tblStorage.
But, the problem i'm having is that the records are not getting created in tblStorage. I have created the relationship and tried different things and have found out that they do NOT create only IF i have "Enforce Referential Integrity" selected on the reltionships! Otherwise, it creates the records perfectly fine, with the right ProductionID on tblStorage, but then the relationship isn't appropriate.
hmmm
Any ideas how I can fix this problem and make tblStorage create the records, with the right relationship?
Thanks!
I have two tables. (and i'll just simplify it because the other info isn't necessary to aide me!)
tblProduction
ProductionID - Autonumber - PK
ProductionLocation
tblStorage
StorageID - Autonumber - PK
StorageLocation
ProductionID
Now. I have two forms. One is frmProduction and the other is frmProduction_Stored.
A user inputs in the frmProduction form and then has a drop down that determines the "disposition" of the items produced.
Once that disposition is selected it will open up one of three forms(depending on the value selected), in this example it is frmProduction_Stored.
It then opens up that form and fills in tblStorage.ProductionID with tblProduction.ProducitonID. And then the user can fill out the rest of information required for tblStorage.
But, the problem i'm having is that the records are not getting created in tblStorage. I have created the relationship and tried different things and have found out that they do NOT create only IF i have "Enforce Referential Integrity" selected on the reltionships! Otherwise, it creates the records perfectly fine, with the right ProductionID on tblStorage, but then the relationship isn't appropriate.
hmmm
Any ideas how I can fix this problem and make tblStorage create the records, with the right relationship?
Thanks!