Needed: Combo Box to reuse removed data later

[applevacross]

I have a combo box which contains all power supply serial numbers. When a power supply gets re-issued to a laptop, I want the serial that gets replaced in this combo to be able to be reused later as opposed to just getting written over. Is this possible without having to creat another table for this field?

Thank you for your help in advance!

 

[gol4]

It depends on the design of your database. If properly designed the serial number of the power supply should not change on the laptop it is assigned to. However based on your statement
"I want the serial that gets replaced in this combo"

Im guessing you have some design issues that may make it difficult to get this number.
What does the sql for your combobox look like?

 

[applevacross]

You might be correct on the formatting aspect, as I have built this entire DB with only one table containing approx 8000 records.

There is really nothing to the combo it is controlled by the the power supply serial field from the table and this is the row source:

SELECT [AppleVac_Inv_DB].[Power Supply Serial Number] FROM AppleVac_Inv_DB ORDER BY [AppleVac_Inv_DB].[Power Supply Serial Number] DESC;

I tinkered with an unmatched query by importing only serials into a new table, however it only shows serials not currently in use.

What I'd like to do, is have the user click the combo drop down and select the powersupply which will go with the corresponding laptop. The serial which precedes this change would just go back into the table for later use. When we get new brand new powersupplies. They'd be able to type directly into this control without having to select at all. And of course the preceding serial would just go back into the table for later use.

I'm not sure how to engineer it to make it work. Hope this makes sense.

Thanks for responding gol4, I appreciate your help!