I am currently building a database for our marketing department. They currently have 14 different databases. I am setting up a single database and importing each of those databases into their own table to provide a more consistent interface. I have the layout figured out and want to copy and paste it into each of the table layouts. The one part that is taking the longest is when I have to specify the field to point the copied fields to the table they are currently in.
Is there currently a way to quickly specify fields? Is there an option that will point the fields to the table they have been pasted into?
My fields are the same across every table, it is currently just a matter of double-clicking the field and then changing the targeted table in the drop down. I was hoping there is a way to automate specifying fields.