August 30, 200817 yr Newbies 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.
August 30, 200817 yr 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.
Create an account or sign in to comment