Suggest a table for the computers, one for pallets (I'd use this as the source for a combo to pick the pallet), a junction table tblCompPallet to show which units are on a pallet, and tblPalletPrice. A computer makes one record in its own table, which allows that unit to be sold individually or on a pallet. tblCompPallet lists each unit (computer) PK and repeats the pallet ID. tblPalletPrice lists a pallet once with the pallet price.
Will take a look at your design in the meantime.
EDIT:
On second thought, please upload your db to your post. I don't like accessing files from drop boxes and such. Some people here will simply not do so.
Compact/repair and zip your db before uploading the zip file.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.