One-to-one relationship?

Databases
1

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:

table accessPoint
ap_id
ap_name
radio1 (value of rc_id below)
radio2 (value of rc_id below)
radio3 (value of rc_id below)

table radio_config
rc_id
config_item1
config_item2
config_item3
.
.
config_item10

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.

2

Add a 3rd “linking” table with 2 fields ap_id and rc_id each row would record 1 radio and access point combination.

3

okay, thanks for the reply.

then I would have this:

table ap_rc
ap_id
rc_id

What type of query would I write to obtain:

all access points with ‘config_item1’ = ‘x’