could anyone help with this I dont know much about database?
Create a suitable database design including appropriate tables, fields, data types, keys, relationships and constraints. Use AutoNumber primary key fields where appropriate. Among the data we need to store about suppliers is the credit limit (maximum amount we can owe) and balance (amount we actually owe). Each invoice and payment should have a unique identifier, be dated in the range January to March 2012 and of course include the amount. Enforce referential integrity and cascade update and delete as appropriate. You might have to modify your database design slightly in light of the questions below.