Hello.
I building a database where I need to store information about customers.
One of the fields is the customers access type. I have 3 options, they can have static IP, DHCP or PPPoP access.
Each of the access types have their own table where the information about them is stored.
Now I want to be able to chose one and store the information about it, and relate it to the customer in the best way. I don't want to store DHCP information for a customer that has static IP access and so on. (If I'm unclear on what I want to achieve please ask me to elaborate)
Anyone got any ideas on how to accomplish this in the best way?
I building a database where I need to store information about customers.
One of the fields is the customers access type. I have 3 options, they can have static IP, DHCP or PPPoP access.
Each of the access types have their own table where the information about them is stored.
Now I want to be able to chose one and store the information about it, and relate it to the customer in the best way. I don't want to store DHCP information for a customer that has static IP access and so on. (If I'm unclear on what I want to achieve please ask me to elaborate)
Anyone got any ideas on how to accomplish this in the best way?