Oh I should probably mention how I need it to be organized!
I need each Mat# and all it's components to be organized as individual records.
ie: Mat#123456, Desc, Comp1#147852, Comp1Desc, Comp2#369852, Comp2Desc, etc
So I don't even know where to begin on this one so I figured I would go ahead and post to see what you folks may know about it! Here we go...
What I Have:
I have an excel table that provides product part numbers, Description, The components within the part number and the component part...
Well here's the thing lol...
I keep seeing that is a RARE situation that you would need to save autofill data in a table so let me revamp my initial question and give you the overall of what I am trying to accomplish...
My table tblFPAData has all the information that goes with a specific part...
Hello all!
I use this forum a lot for getting my questions answered but this is the first time I am asking myself. I have been a long time excel user and I am new to Access. I have started a database and what I need it to do is simple I'm sure but I'm at a brick wall with it! :banghead:
Here...