Constructing DB Tables

[Arvin]

Hello,

I have been tasked with creating an "Customer Service Matrix" which will display information such as;

Customer Name, Customer Number, Account mgr, and a list of various services they are eligible for.

The basic concept I have is .... there will a drop down from which one can select a customer and with a OnClick cmd all related information will autopop. however the issue I'm having is with the db table structure. One customer can have multiple customer numbers...so how would a create my tables ... or is this a relationship issue?

Any help/suggestions are greatly appreciated

Thank you in advance.

 

[Rabbie]

Why will a customer have multiple customer numbers? Is this dependent on their address? More information please

 

[Arvin]

Why will a customer have multiple customer numbers? Is this dependent on their address? More information please

Thank you for the quick response!

A customer can have multiple customer numbers because they are eligible for more than one line of business ... for example...

Customer Name - Abc Inc
Customer Number - 12345 = Internet
Customer Number - 54321 = Billing
Customer Number - 78945 = Data

I hope this is the info you req... thank you in adv....

Arvin

 

[Arvin]

**** NOTE ****

These same customers that have multiple customer numbers based on line of business can also be subscribes to various service options with a particular LOB. For example

Customer Number - 12345 = Internet = ADSL, Wholesale DSL, Dialup
Customer Number - 54321 = Billing = service opt1, service opt2
Customer Number - 78945 = Data = T1, LAN

and so on ....

 

[Arvin]

After some further thought ...I'm thinking that I would need to create 2 tables....

Table 1 would list all customers and their corresponding customer numbers ...

Table 2 would list all services the customer has based on their customer number....

and then create a relationship between the 2 table via the customer number column.

Does this make sense? .... it does to me but i would like to confirm this with someone that more knowledge on Access then myself ....

Thank you in advance.

 

[Arvin]

Is there anyone that can assist me with this ?

Thank you in advance