Microsoft Access - Northwind Traders

Question

Hello. I got it fixed. Thank you.

Original Text: Hello. I downloaded the 'Northwind Traders' template onto my computer to use for a pretend shop game I was playing with my dad. When I click the button on the order form which says: 'Invoice Order', there is a popup box that says something like: All items need to have status of Allocated. At the moment the status is: Black Ordered.

Please can somebody help me,

Thanks.

Answer 1

This isn't an Access error message; it's one that the developers of Northwind programmed into the button code. What I think it's saying is "You can't generate an Invoice for this order until all of the items in the order are Allocated"; if some or all of the items are Back Ordered (check your spelling!) then the program won't generate an invoice.

I'm not sure what you want to do - change the business rule? change the code? or what?

Answer 2

What do you need help with?

You meant "Back Ordered" which means that the products are not in stock, and thus it would be rude to invoice the customer.