Multi-Fields link to one table...Part Number...Description

[MrsTFB]

Hey,
I'm trying to allow the user to enter up to 4 part numbers in separate fields. I've named the PartNum, then PartNum2, PartNum3, PartNum4. The problem is that I have an information table that links with PartNum and gives the description. Of course I have Desc, then Desc2...etc. However, I can't get PartNum2 and the rest to relate to Desc. Am I making sense here? I can't figure out how to get the description information when the fields are named differently.
I'm not that great at programming through Access, so I'll need simple instructions.

Thanks in advance,
MrsTFB

 

[SkipVought]

MrsTFB,

What???

It's USUALLY not a good idea to have the same data field in multiple columns in a database.

What is your reason for this design?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[MrsTFB]

I thought that was very confusing...
What I have is a Part Number table with a separate table to update Descriptions. On a form, they want to enter the part number and have the descriptions (which can get lengthy) to appear in the description field. But of course, they want the possibility to add more than one part number ( up to 4).
I can't figure out how to connect the additional part numbers to the descriptions.
There's probably an easier way, but I'm not very proficient here.
Thanks,
Mrstfb

 

[SkipVought]

Sorry. I thought you were desiging a TABLE with multiple PN/Description fields.

I think that the only way to do this is programatically, loading up an array to then Insert into the table.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884