Concept

[Crilen007]

Hey, I am trying to put my head around the concept on something.

Basically, I am making a Database to keep track of strata payments for an apartment building. (they are paid each month for each unit).

I have my units table, for each apartment in the building, but I am unsure of how to do this next part.

some people pay 6 months ahead, and I want to beable to mark that down, so do I need a table that has dates? or do i use some kind of function to get the dates (first of every month?)

I am just unsure of the table structure required. If someone could help me out I would really appreciate it =)

Anyone on MSN who has a good idea of what I need? Please, PM me and I will give you my MSN user.




Also, on another note, is there anyway to retrieve the month name from the number?
I've always just made a table and linked it.

 

[KenHigg]

Crilen007,

I think I would consider doing maybe a period table where each record represents one payment period. Say record n would hold payment information about unit A for month X. Then do a payment table that would hold information about a payment a customer made. Say cust 123 made a payment of n dollars. Then build the logic into a form that would distribute the payment accordingly....

The UI flow would be something like:

1. You pull up a payment form,
2. Select a customer from a cbo
3. Enter check info, amount, etc
4. On a subform - enter the payment period(s) and the amount to apply...

Just an initial thought...

Cool db,
kh

 

[Crilen007]

Well, When I print a report, I want to see a a full year, 6ahead and 6back. (one would be current month).

So I can track people who havent paid, I assume I would have to make a crosstab or something... hmm, I suppose I will have to play around..

 

[KenHigg]

When you get at what you think are the final tables / relationships, post it and we'll give it a look to see if you'll have to do crosstab. I really don't think you'll have to...

kh

 

[Crilen007]

Well, what I think im going to do, is create an auto invoicer, so each month I can run it, and invoice them for that month, then after words, I can check off if they have paid it or not..