Relative rookie with Access here. Building a database to track contract workers. Fields consist of such things as name, first and last, employee number, and about 30 other pieces of data.
The problem I am having is this. Upon normalizing the database from one massive table to several smaller tables and creating a form for clerical staff to input and edit records, I am finding that when a NEW record is input it finds it way into the appropriate table, BUT when one tries to find this NEW record within the FORM in order to edit it...its not there. Are special querys the answer or shall I utilize subforms within the main form so that NEW records are visible within the FORM?
Thanks.