Access Database help

[kunal78]

Hello,

I really need help with few things I am trying to figure out here in Access 2003.

NO. 1

I am creating a database based on three different tables. I want to be able to pull few fields from a primary table to other two secondary tables. For instance, Std Main Table has Estimate #, Customer name, Customer number, part number, order revision, and other order information.

Now, if make a form based on secondary form then I want the form header to show fields from Std Main Table (Estimate #, Customer name, Customer number, part number). SO HOW CAN I DO THAT?

NO 2.

One of my form has a combo box that pulls a Operation Description. However, I want a text box next to that combo box that would automatically pull the code related to that operation description.



Sorry, I am new with this thread chatting and I don't know how to describe my problems in details, though, I would really appreciate your help in this matter.

Thanks in advance,

[keyvanrahmadi]

I take it you have already designed the tables, so if its possible i would like to see the fields, so i can duplicate it for myself to give a better answer.