I used this forum several years ago and it was a big help, I long forgot my user name.
I'm attempting to build a database to record the profiles of medical devices. I've got most of the design down but I got stuck.
The medical devices use computer ports to communicate with other devices on our network. I would like to keep a record of the ports the device uses, my problem is some of the devices use a couple of ports, while others can use 15 or even more. I don't think it makes sense to add ports as headers so I was thinking of linking another table that would record the ports in rows and use some other kind of data to keep the reference to the device that used the port. The problem I'm running into is I have to enter the part number again and again and again.
I'm not sure if there is a better way to design the database, I'm not in love with the design, or is there a way to enter the part number once and keep repeating it for a number of rows.
I'm not sure if I described it clearly enough but any advice would be helpful.
Thanks