form needed

[Daveisalwayshere]

Hi guys,
I have a ScaffoldPartLogTable that in the first field of the table is the primary key(scaffold Tag) the second field is a Child Job number identifier which is easy to handle. the rest of the tables field are part numbers(roughly 240 of them). what I am trying to track is the quantity of each part per tag number

When a worker completes a scaffold he sends an Excel report that lists all the part numbers in the first column and the quantities in the second column. the problem is there is usually only about 30 different items in the list and they arent in any order. is there a way that i can create a copy paste form for this? or do i need to change the way i have my scaffold log table set up in order to accomplish this. I would like to make this cut and paste as fast as possible as I have roughly 100 scaffolds per day being erected.

I have an article list in another table if that helps I am a beginner at this

 

[EternalMyrtle]

I am not 100% sure I understand this but from your description it sounds like your table structure is way off. You should NOT have 240 fields each with a different part number. Have one field called part number in a parts table.

Then you will have no problem sorting

 

[Daveisalwayshere]

Thanks,
I did restructure my table like that. after hours of research i did figure it out. now i am on to wage increases and how to accomplish them without affecting old data. this might be a tricky one

 

[EternalMyrtle]

Ok, good. Handling the wage increases should probably be a separate question.