J
Joe Cilinceon
What I need is a method to handle multiple auto pay accounts with the
following setup:
TENANT (General tenant info is kept in other tables such as address, phone
numbers etc.
CustNo (Unique number to tie this table to all others.)
TENANTAP ( holds credit card data such as number, expire date etc)
CustNo (# field that ties to other tables.)
UNITS (holds storage space data)
UnitNo (number field)
LEDGER (holds all account data based on which tenant rents what spaces)
LedgerID (main field in this table 1 for each CustNo -> Unit combo)
CustNo
UnitNo
Now each tenant can have more than one Units creating a new LEDGER record
for each combination. However I store 1 credit card number under the CustNo.
I'm looking for a way to have to have unit paid or not paid by a given card.
I also don't want to store the credit card data more than once per tenant.
That is not to say I'm not open to multiple cards on a single tenant.
The only thought I've had so far is add another table with a link to a
credit card account and allow for multiple accounts.
following setup:
TENANT (General tenant info is kept in other tables such as address, phone
numbers etc.
CustNo (Unique number to tie this table to all others.)
TENANTAP ( holds credit card data such as number, expire date etc)
CustNo (# field that ties to other tables.)
UNITS (holds storage space data)
UnitNo (number field)
LEDGER (holds all account data based on which tenant rents what spaces)
LedgerID (main field in this table 1 for each CustNo -> Unit combo)
CustNo
UnitNo
Now each tenant can have more than one Units creating a new LEDGER record
for each combination. However I store 1 credit card number under the CustNo.
I'm looking for a way to have to have unit paid or not paid by a given card.
I also don't want to store the credit card data more than once per tenant.
That is not to say I'm not open to multiple cards on a single tenant.
The only thought I've had so far is add another table with a link to a
credit card account and allow for multiple accounts.