Software Design Problem: VPN Accounts

[eluser]parham90[/eluser]
I didn't think of that. I like your second suggestion more, but there is a problem in that one, too. The client wants the kind of service the user is currently using to be displayed. If I add another row with the new service, it'd be a mess trying to figure out which one he's using now. Maybe not much when there is two or three rows for the same user, but what if he has used a hundred services? Going through them, I think, would take a long time when the table gets big. Just an assumption though. I don't have a scientific basis for it.

And another thing. The client, as the admin, wants to be able to change the service the user has subscribed to (E.G. if he later on calls and says he wants to change the service and such). So, the data needs to be highly dynamic.

Thanks a lot for the suggestion so far.