Huh? You think something is a bug that you most likely don't understand,
and I don't have a clue what you are referring to above and I do
understand. :)
The CustomerID field is what links the SubAccounts table (Services) to the
MasterAccounts table (MBRs). Main the maExpireDate (MBR expiration) and
Active are the two fields used from the MasterAccounts table.
When you add a user to the database, you need to first add an entry to
the MasterAccounts table. Once you have added that entry, the database will
assign it a CustomerID. Next, you will add one or more services from that
MBR into the SubAccounts table, with that CustomerID. Each SubAccount
record will also be given its own AccountID automatically.
This is what we call a two-tier database layout to allow a single billable
customer to have multiple services. You may want to take a look at Emerald
if most of this doesn't make sense, because Emerald hides all this database
technicalities from you.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com