Someone Please Help I still dont get it. I am new to access

[Amit112]

There are 3 fields:
1. Part Number
2. Bore Size
3. GM Part Number

if Part Number = 600002 then
Bore size = 58
GM part number = 12591004

if part number = 600003
Bore size = 58
GM part number = 12593214

if part number = N/A
bore size = 65
GM part number = 12589382

if part number = 600004
bore size = 72
GM part number = 12591846

if part number = 600000
bore size = 77
GM part number = 12588244

if part number = 600001
bore size = 72
GM part number 12593591

- so I am actually basing it on Part number
is there a simple way to do this
thanks again

THANK YOU

Please give me a full description I am not getting it. Cal if you read this I got your mock up thank you but it wouldn't open on my computer for some reason. Thanks