If field =15 save in two tables

D

deb

I need suggestions...

I have a main form f001ProjectReview(ProjectID) that has several tabs that
contain subforms.

One of the subforms is f015KeyMilestones(ProjectID-Required,
UnitNo-NotRequired, KeyMilestoneSubID-Required(list of milestones form
tKeyMilestoneSub table) Fields are UnitNo, KeyMilestonesSubID, PerContractDt,
ActualDt and Notes.

Another subform is f022Shipping(ShipID, ProjectID) Fields are UnitNoOpt,
KeyMilestonesSubID, PerContractDt, ActualDt and others.

If the KeyMilestoneSubID = 15 then I need this record to be listed in both
subforms
because it is a milestone and it is a shipping record. I do not want the
user to enter the same data in two different areas. When they enter the data
in either subform, I want it to show in both subforms.

Each subform will have other records but the common records I need in both
tables and both subforms are the ones with the KeyMilestoneSubID = 15

I am lost as to how to make this work. any suggestions?
 
D

Douglas J. Steele

Use queries with appropriate WHERE clauses as the RecordSources for the
forms.
 
S

S.Clark

In the Code behind form, when the value is correct, then use an Append query
to write the data to both tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top