Combining multiple tables

[Duncan]

Hi,
I have 24 tables for different student subjects with 10 fields in each. All the fields in each table have the same headings and each field has combo boxs (multi-valued fields) with different data in each to select from. The only similarities (links) between the tables are student numbers. For example; a student with ID 1234 could access 3 out of the 24 tables making selections from the combo boxs (thus they only do 3 out of the possible 24 subjects on offer). I have produced the user interface forms from the tables etc.


What I need to do and can’t is have all the data from all the tables dump into the one table then I can query the table and extract (group) the students answers under their one student name. I have tried Union queries and appending and SQL but all seem not to be able to work with multi-valued fields (combo boxs). I’m new to access and teaching myself as I go.
Cheers Duncan

[orange]

You require changes to you current data structures(tables) and relationships.
Get your structures designed before you get into the nuts and bolts of Access.

You need to do some research on Normalization.
See the links at this site for Normalization and Entity Relationship diagrams
http://www.rogersaccesslibrary.com/forum/topic238.html

There are a number of models related to Students here. You may be able to use parts of these in your project.
http://www.databaseanswers.org/data_models/index.htm

Get rid of the Table level lookups see http://www.mvps.org/access/lookupfields.htm

Good tutorial here http://www.databasedev.co.uk/student...ata_model.html