Question Custom table based on users choice of fields.

[matiyas]

I want to create a form where by the user can select the fields he requires and the table is created.
example: i have a table of subjects like maths,english,french,chemistry etc,
the user can choose what subjects are available in that particular school and therefore a table is created based on the chosen subjects.
is there any way it can be done even with vba? :banghead:

 

[spikepl]

Google and read the subject of data normalization. Similar items go into one column of one table - not into different columns (of perhaps different tables). In this manner a new subject would just be a new record. Variable tables are a total nonstarter (with few exceptions) and total PITA - because you'd also have to have variable queries, forms and reports ...

 

[matiyas]

thanks spikepl,
i have normalized the tables, but the problem comes in when entering records.
you see, i have to make a report-card for each student that displays there results....i cant figure out how that would be done!!

 

[catalin.petrut]

You want in the same db to use different schools with specific classes?

 

[matiyas]

I think i have resolved the issue after careful consideration of data normalization as spikepl suggested,
mh! needed just to think a little deeper,

on to the next " :banghead: "one