W/O racking my brain ...

[dcavaiani]

Can anyone advise? I have a Header and Detail table (1 to many) connected with a RecordId. The Detail records are 'checked' off with an Invoiced Date in a random method (Selected by Invoicing for an individual customer id).

Once all of the detail records ON ONE SLIP are ALL Invoiced, what would be the easiest way to flag the Header record as Invoiced as well, so that the Header/Detail combo will be blocked from the form I use for data entry/update (which I already have programmed).

This is an app where the Header is the "slip" which a Contractor gets from say Home Depot. The items purchased by the Contractor CAN be for MORE THAN one Customer. Once the Contractor BILLS one of his customers, the Detail lines from ANY/ALL of the "slips" FOR THAT CUSTOMER become LOCKED with a Contractor Invoiced Date.

 

[spikepl]

When posting, please supply a title describing in a few keywords the actual issue at hand, and not your state of mind. This is important for all subsequent readers, because at the bottom there is a very useful list of Similar Threads. That actually gives relevant threads, unless the title is weird or unfocused. Just see the list at the bottom of this thread for an example of how not to do it. Also "help", "issue", "problem" are all givens and not required to be repeated; this is why people post.

For examples of how to do it, just see most of the other titles in any thread.