Updating records in a related table

Hi;

I have two related tables, Correspondence and EPDBchcklst. The tables are
related via record ID which is autonumber. After a person enters a
correspondence into the DB, they are to click a button which brings up a form
based on the EPDBchklst table containing a checklist of items they need to
check off.

The record id on the checklist form is bound to the record ID of the main
form (Correspondence) & so automatically fills in the record id number. My
question is, whst is the best way to get the EPDBchklst table's RecID to be
updated to reflect what is on the form.

Maybe I'm not seeing the forest through the trees...


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200508/1

re: Updating records in a related table

so, tblCorrespondence has
correspondenceId (pk)
....
more fields
....

and tblEPDBchcklst has
checklistId (pk)
correspondenceId (fk)

so build a continuous form based on tblEPDBchcklst and a form based on
tblCorrespondence

then drap the checklist form on the correspondence form to create a
subform

re: Updating records in a related table

Hi;

tblCorrespondence has:
ID (pk)

& tblEPDBChkLst has:

RecID (fk)

I have the Corerspondence form built, and I have placed the EPDBChkLst form
on it. Now I have this problem:

I navigate on the form using buttons at the top of the form which, when
clicked, bring you to Page 1 or Page 2 (I have a page break between the
Master section & the detail subforms on Page 2). So, I've added another
PageBreak below Page 2, but when I click the button to go to Page 3, Access
says the page does not exist. UGH!

Now I have a Page Break problem that doesn't make sense to me...I had other
pages before (4 altogether) & had removed 2 of them during my re-design...

Any ideas on the Page Break thing?

Also, I have seen the continuous form property before, but am not familiar
with it....what is it's purpose as oppossed to single form?

Thanks!

lesperancer@natpro.com wrote:[color=blue]
>so, tblCorrespondence has
> correspondenceId (pk)
> ....
> more fields
> ....
>
>and tblEPDBchcklst has
> checklistId (pk)
> correspondenceId (fk)
>
>so build a continuous form based on tblEPDBchcklst and a form based on
>tblCorrespondence
>
>then drap the checklist form on the correspondence form to create a
>subform[/color]


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200508/1

re: Updating records in a related table

Nevermind..figured it out. I was trying to go to page 3 from within the
subform instead of the detail section of the main form.

Pamela wrote:[color=blue]
>Hi;
>
>tblCorrespondence has:
>ID (pk)
>
>& tblEPDBChkLst has:
>
>RecID (fk)
>
>I have the Corerspondence form built, and I have placed the EPDBChkLst form
>on it. Now I have this problem:
>
>I navigate on the form using buttons at the top of the form which, when
>clicked, bring you to Page 1 or Page 2 (I have a page break between the
>Master section & the detail subforms on Page 2). So, I've added another
>PageBreak below Page 2, but when I click the button to go to Page 3, Access
>says the page does not exist. UGH!
>
>Now I have a Page Break problem that doesn't make sense to me...I had other
>pages before (4 altogether) & had removed 2 of them during my re-design...
>
>Any ideas on the Page Break thing?
>
>Also, I have seen the continuous form property before, but am not familiar
>with it....what is it's purpose as oppossed to single form?
>
>Thanks!
>[color=green]
>>so, tblCorrespondence has
>> correspondenceId (pk)[/color]
>[quoted text clipped - 11 lines][color=green]
>>then drap the checklist form on the correspondence form to create a
>>subform[/color][/color]


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200508/1