add or change record error message

[jduke44]

I am getting a "cannot change or add a record because a related record is required in table 'tblOrder'". I have scoured this site so forgive me if there is a post already on this.

My Order table has:

OrderID
CustomerID
SalesTaxRate


My Order detail table has:
OrderDetailID
PoNumber
TransDate
ProductID
OrderID
QuantitySold
QuantityReceived
QuantityOrdered
TransType

I wasn't sure if by this you could point me in the right direction as to why it is saying this. I am very new to Access so bare with me. Thanks

 

[MStef]

Yes, you can't to add a record in "Order detail table" if there is not a record
with the same OrderID in "Order table".
Because of Relationships "Order table" - "Order detail table", One - More.

 

[jduke44]

Thanks for your response. I am not actually changing or adding the record. I know I didn't explain what I am doing but here goes. I am trying to setup a database that keeps track of my wifes transactions. I have been searching this forum and others to try to get the concept of how to do this. I have everything setup to where I can have her place orders which goes into a table called 'tblOrderDetail'. Now I need to set up a form that keep track of her supply order.

From what I understand I would need to use the same info from 'tblOrderDetail' to track that info. I know it is old style accounting but until I understand it I am having the amount ordered, amount received, amount sold in different columns. So I am using the same info from 'tblOrderDetail' for the purchasing products as I am for the selling them. This is where I am getting the error message.

I guess my question would be if I am on the right track?

No one seems to have a simple database as an example when they are buying and selling things and keeping track of inventory. It is either on eor the other. I have the templates that Microsoft provides but they are incomplete (at least it seems).

Hopefully I am not wasting anyone's time by not knowing too much as I stated before, I am very new to access. Thanks for your help.