[SOLVED]
Hello All,
I have recently started to teach myself Microsoft Access and I managed to create a pretty decent Movies database for my collection.
I have moved on and am now trying to create a Car Parts database (attached) for a made up Garage which will store the care parts details along with the Employee/Customer details which has been okay. However, from reading around the web, I see that when creating an invoice, I need two seperate forms; a master and a details form. I have done this but when I test my master invoice I get the following error message:-
'You cannot add or change a record because a related record is required in table 'Invoice Master' so I guess I haven't linked my tables correctly.'
I'm no Wiz at Access but am keen to learn - any help or guidance would be much apreciated.
Cheers,
Billy