I'm having a university project where I have to make a database on MS Access .
The subject is :
We have a company that deals with trading. You need to make a database
to serve cost and product discounts for customers. The database must
-Nomenclature of customers with fields of your choice
-Nomenclature of items with fields of your choice
-Nomenclature, which represents individual prices for
certain items pertaining to specific customers.
When selecting a customer, the database must show all items with
the respective prices depending on whether a customer is using it
individual prices or not.
I am newbie in database management and its really hard for me at this moment,
so any help wil be appriciated ! :)