I have a system running that uses data stored in a Misc_Table table. The user is presented with choices from various combo boxes loaded with data mainintained in this table. I use various index tags depending on the combo of interest - County, Intake Reason, ... I have developed a "RightClick" method that allows me to maintain the table on the fly from within other form. The right click calls a maintenance form and passes the appropriate information ie Add, Edit, General and what index .... The maintenance form is called using a PRIVATE data session ( I would like to keep it this way to preserve my sanity tracking who's on what ).

This workes fine except I just noticed that when I add new records to the table they are not showing up in the indexes. I don't understand.

Thanks in advance for any advice you can give

Terry