Hi,
I have a header table with entries for employers and End of quarter (EOQ) dates, one entry for each employer-EOQ combination. A detail table has one or more records for each employer-EOQ.

I need to update records in both tables for an employer for one or more EOQs, but typically not ALL EOQs.

So, I'm trying to figure out how to create updateable views that SELECTs one or more EOQs (I could use a view that collects all EOQs and just updates the EOQs i want to change, but that seems like overkill...the number of related records in the detail file may get very large).

One solution I've read about suggested using a temporary DBC and creating the view w/the specific EOQs required.

Is this the best way? I'd tried using view parameters, and IN/INLIST but couldn't get it to work with a list of dates.

Any suggestions/comments? TIA, J