J
jbphoenix
I have a main form with with the Customer_Order table as the record source.
The Order_ID is the primary key. I have a subform with the RMA table as the
record source. The RMA_Num is the primary key. I had to make it the primary
key because if not when a new order was entered a second order was also
created but without any data in the RMA table. But since I have made the
RMA_Num a primary key I keep getting "Index or primary key cannot contain a
Null value." I keep clicking OK and filling out the form and it works fine
but I don't want the users to have to keep clicking OK. Any ideas on how to
fix this?
Thanks for any help.
The Order_ID is the primary key. I have a subform with the RMA table as the
record source. The RMA_Num is the primary key. I had to make it the primary
key because if not when a new order was entered a second order was also
created but without any data in the RMA table. But since I have made the
RMA_Num a primary key I keep getting "Index or primary key cannot contain a
Null value." I keep clicking OK and filling out the form and it works fine
but I don't want the users to have to keep clicking OK. Any ideas on how to
fix this?
Thanks for any help.