Hello All!
I have been trying to figure out a way to use record 'templates' (for lack of better term) with various combinations of generic data to create new records and speed data entry.
I have a main table with PK linked to two other tables. I was thinking I could just copy the three tables and use these to hold my template data. The user would populate the generic data in the template tables that could (hopefully) then be used to create new records with that template data in my main table and linked sub tables. Once the user creates a template I was hoping there could be an easy way for the user to select that record template (probably from a combo box) to push that data to the main table. If it were just the single table I know I could use an append query to add a new record to my main table but I don't know the best way to copy data from one table (and its linked sub tables) into another table (and its linked sub tables).
I could probably also figure this out with VBA but I am not the best with it and my code would most likely be pretty clunky.
I hope this make sense what I am trying to do. Let me know if I need to clarify anything!
Thanks everyone!
Evan