Hello, All! I would like to load two tables from one form. As part of this, I would like to load multiple records into one table that are associated with the one record in the other table, with the same form, like a looping routine.
Specifically, I would like to input a maintenance record in one table, including machine name, date, time used, and through the same form, enter multiple records for parts used on this maintenance job, keyed on the machine name. Or machine name/date?
Is this possible, using form design? I cannot do macros at this point. Anyone's suggestions would be greatly appreciated.