Hello,
I'm working on a database for our school that tracks student assessment scores. Each assessment has it's own layout and table. The table structure & layouts of the assessments are pretty much the same. I can't combine them, because my boss wants it setup this way.
Here's my question. I create Table 1 and Layout 1. I wish to duplicate both to Table 2 and Layout 2. How can I do this, without having to change each field on Layout 2 to table 2. (When I duplicate Layout 1 to 2, the fields still connect to Table 1).
Is there a way to select multiple fields and point them to a different table?
Thanks.