Can someone please lend expertise to the following? Also, is this called a one-to-one relationship?
I have a table containing name and id of a wireless access point. Each access point has two or three radios. Each radio has ten separate items requiring unique configuration details. I would like to do this:
radio1 (value of rc_id below)
radio2 (value of rc_id below)
radio3 (value of rc_id below)
I feel doing this would be better than having the accessPoint table containing 30 different fields.
My question is, what is the best method for tying the two tables together?
Thanks in advance.