AnsweredAssumed Answered

Part Setup Question

Question asked by BatuhanGizer on Dec 3, 2011
Latest reply on Dec 4, 2011 by BatuhanGizer

Title

Part Setup Question

Post

Hi,

I am trying to set up a new database for payment plan which then I will set up a relationship between a general database with a portal. But for the moment, I am trying to set up a system where there will be an ID (for the inventory part that we are selling) and PIN (for the clientele).  What I did for now is;

ID: 101

PIN: 11001

Price: 1000 $

Date               Explanation               Invoice Number        Amount    

1/1/11        January Payment               1                        100

 

But what I couldn't figure out is, for the same ID and PIN, there can be 15 or 20 payments.  In the example above, there must be 10 payments in order to reach 1000 $ with every payment being 100 $. So what I am trying to have is something like;

 

ID: 101

PIN: 11001

Price: 1000 $

Date               Explanation               Invoice Number        Amount    

1/1/11           Payment                       1                        100

2/1/11           Payment                       2                        100

3/1/11           Payment                       3                        100

4/1/11           Payment                       4                        100

5/1/11           Payment                       5                        100

...

 

Thanks in advance!!

Outcomes