Member Avatar for tirso

Hi to all,

I want to create an application containing a lot of fields, my problem is the client want to maintain the records of payment and the date. I have created database containing only one tables. How can I handle this kind of database management, the goal is, if the customer paid for this month, then add to the database but the problem is for the succedding month. how can I keep the old records. I know that the customer information doesn't change but the payment and date will varies. I am thinking that I have to create field with fieldname (month and year example for this month June_2008, for next month july_2008 and the value is the date inputted which the user made a payment) but I am using microsoft access database and i don't know the limitation of number of fields and maybe it become slowly if it takes to much field. I am using visual studio 2005.

Please help me.

Thanks in advance

  • 3 Contributors
  • 4 Replies
  • 88 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by sierrainfo
Member Avatar for sierrainfo

What you can do is create a Payments table with the customer id as Primary Key, paymentdate, and paymentinfo. Then store the payment recieved according to customerid, paymentdate. This will be easier to habdle and Query. Please read about Database Normalization if yu can.

Member Avatar for iamthwee

>I have created database containing only one tables.

WWWWWWWWWhat?

One table, there is your problem/

Member Avatar for tirso

Hi sierrainfo,

thanks for the help.

Tirso

Member Avatar for sierrainfo

I am glad to help. If your problem has been solved, please mark this as solved.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.