Ive got a "Personnel" form with multiple tab pages. The first tab page is basic employee information, the next couple fo tab pages are "tabular" and designed to hold addresses, phone numbers, contacts etc. These tabular tab pages tables are linked to the person table by person_id that is generated with a basic before-each-row trigger on the person table. If I add a new person, Save that record, then re-query the database for that person, I can go to the address, phone, etc tab pages and add those bits of information. However, if I just add the new person, save that record, and go on to the other tab pages, the address, phone etc. data is not saved. Apparently I need some kind of post-save-record-requery trigger. Can anybody point me in the right direction. I dont want the user to have to manually re-query the new employee.
thanks for any suggestions
thanks for any suggestions