Lease Database

[oliver_penney]

hi all

i have been assigned to build a rent/lease database

our shops have rent agreements that depend on a minimum guaranteed rent, but if their revenues exceed a certain amount, they pay a certain percentage of their revenue, but the percentages vary per sales type, eg. tobacco, food/drink, phone cards

any hoo...

i'm just wondering what is the best way to do a time sensitive database with [rent start] and [rent finish] fields and [rent per food&drink] sort of thing

ta in advance

ol

 

[Anne Troy]

We can probably answer questions that are a lot more specific, but this is pretty broad.

Can you narrow it down?
Where are you having problems?

 

[Norie]

Do you have any existing data?

If you do then I'll have a look at it.