Form controls, auto fill Help!

[jesswoo]

Hi, I may have posted a question sort of like this before and I don't think I asked it right because I never got an answer.

I have a database that is used for a service company. There is a schedule to display active orders, a specifications form to print out the specs for each part and various reports.

The probelm I have, which may be due to structure, is that I have to type in the part information (ALL OF IT) in both the workorder form as well as the parts specifications form. Once I put the part in the specifications once I can pull up the info whenever but i am trying to find a way to choose a part on the workorder form and all of that parts information automatically fills in. The part info will never change or be altered.

I have tried doing this by creating a workorder form from the parts information table but whenever I put in a new order and autofill it changes the first orginal entry. I need to be able to keep track of the orders as well and this just changes the last entry. I have also tried creating a form from a workorder table that has the part info fields from the parts info table, it does not let me autofill at all this way. I tried creating a macro that pulled the fields I wanted but from the form it does not fill them all in.

Can someone give me an example as to how to do this and maybe how my tables should be set up for it all to work?

Any response is greatly appreciated

 

[jdraw]

There is a tutorial here that develops a process to take business facts, turn them into tables and relationships; and design a well-structured database. see
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

 

[jesswoo]

I enjoyed reading that but it does not have anything about filling in fields based on a selection from another.


I will post a database with a few sample data pieces in it. I think I fixed my table structure which is really all I have right now for this but basically from the ProcessOrder Form I would like to be able to choose a partNumber and have the corresponding PartDescription, PaintCode, and PaintDescription fields fill in.


Doing this from a combo box where it finds a record on the form based on the choice does not work because I cannot create new records only edit the old ones. I think I am gonna need some code, if there is a macro way to do this that would be awesome.


All responses are greatly appreciated.

 

[veraloopy]

Can't open the attachment, you've attached the lock file I think