If field =15 save in two tables

  • Thread starter Thread starter deb
  • Start date Start date
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?
 
Use queries with appropriate WHERE clauses as the RecordSources for the
forms.
 
In the Code behind form, when the value is correct, then use an Append query
to write the data to both tables.
 
Back
Top