how to do data entry to a table from a form used to query another tabl 1

[mamadali]

Dear members,

I have created a form that queries a table from another access database to look up: a project name, the project number, and the job number.

On the same form, I would like the form to automatically enter/copy "the project number" in another control for a second table along with maunual entry of other information such as a contractor's name, address,... in other controls.

The idea is basically two things:

(1)to check and make sure that such a project exists as well as forming a primary key in the second table which is a field in the first table. the reason not to put it all in the first table is because I cannot change, modify or enter data in the first table.

(2) use the newly populated table to link to the first one or other tables for gathering information and producing reports.

Thank you.

mamad

 

[JerryDennison]

Open the table that you do want data added to and change the lookup property of the project number field to get it's info from the other database field. Then wherever you use this field it's choices will be limited to only those that are found in the other table. You could simply do this at the form level as well but you'd have to redo it everytime you needed to make the choices. If you do it at table level then it basically becomes the default.