Auto Populate a table field from Combo selection

[Guitarcam87]

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 is what I am looking at.

I have a Table (tblFPAData) that is being populated with entries from a form I created. There are several fields but if I can get an answer for one relationship then I can repeat it for the others.

In tblFPAData there are the fields MaterialNo and Description.

I am creating another table called tblSchedule and using a form to enter the information. I need the user to select the MaterialNo from a combo (cmbMaterialNo) and the then table auto populates the Description from tblFPAData.

You help is greatly appreciated!!!!

PS. I am not using VB so that type of coding is somewhat foreign to me.

 

[pbaldy]

Does this help?

http://www.baldyweb.com/Autofill.htm

 

[Guitarcam87]

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 number (Part number, description, plate number, etc.)

I am creating another form where the user can schedule a job for a specific part. They will manually enter a couple fields (Order number, total quantity, etc) and I would like them to select the part number from a combo. When they select the part number I want that to auto fill the relevant information on the form and save it in the table so i can pull a report on the current orders.

Am I going about this the wrong way? Or is this one of those RARE cases where I do need to store the data?

 

[pbaldy]

I personally would not store a description, unless it was going to be customized and thus potentially different for each time the same part was used. I would probably save price, since that will often be different over time (part sells for $5 today, $6 next month).