How to change tables

[aavgeek]

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.

[bcooney]

Each assessment has it's own layout and table.

That certainly sounds like an improper data model. Not knowing more, each assessment should be a RECORD, not a table!

Why don't you describe your data in a paragraph and we'll help you with a proper data structure.