Hi guys,
Firstly, I am a complete beginner with zero Access experience. I am attempting to create a simple one to many database for RMA's where one customer sends in multiple items. I have the form setup and the tables built but my relationship is not working and I am sure I have done it wrong. When I create a new record using my form and try to save it I am getting this error "The Microsoft Access database engine cannot find a record in the table <name> with key matching field(s) <name>. (Error 3101)"
This should be very straightforward table design but I am not getting it so I thought I would ask for some help from the experts. Here are some screenshots of my table/relationship structure.
Customer table (Company)
Table to hold RMA's (HH RMA)
Relationship
Thanks for looking and offering your guidance in this endeavor.