Access- Updating a row with a form

[dingogal]

I've been playing with a database for about a week and finally decided to do away with my pride

I have a form created, and two tables: Job #, and Scope Change # (1-n relationship: 1 job change can have many scope changes). The Job table has only Job # and Job Name, whereas the Scope Change table has multiple fields referring to the actual change itself (when it was submitted, who initiated it, is it approved?).

Questions:
1) Is there a way for the Job # to be entered on the form and have the other fields auto-populate if there is an existing row for that Job #?
2) Assuming there isn't, I want to be able to update a pre-existing row using the form (ie. if the form is approved after the Change is entered on the form, I want to be able to have my assistant change this information using the same form).

Any help is appreciated-
Tabitha

 

[ajdesalvo]

Create a continous form for the scope table, this will be your sub form for the Job main form you will also create.

After creating and closing the sub form (call it frmScope), create main form (call it frmProjects).

Insert the sub form (frmScope) in the main form (frmProjects) using the Job# field as the Master and Child link between the Job abd the Scope records.

On the main form, place a combo box to look up the Job # you wish to see on the screen.

You will see the Job and any associated Scope records. New Scope record created from the main form will automatically have the Job # entered to maintain the relationship.

Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"