Hello there,
I’ve been told that I can use the “Recordset” & “Recorset Type” in order to create table with multiple same type fields but with different captions, & in order to do this I must add the ADO 6 or DAO 6 library , how? I don’t how to add the ADO or DAO 6 for only I havr the version 5.1, so from where can I download it ??? & can anyone give me the structure of the recordset by an example ? This would be soooo much help 4 me.
Jinane

Welcome to UtterAccess!

Why would you want to create multiple same type fields? What exactly do youmean by this? Can you post the structure you wish to accomplish?

ok, thx Jerry here's the table structure
i have an autonb field
a field "A" text 4
Nb of fields (this depends from other table RECORDS) X with Nb-->integer type
A field Note As Text 130

..
i will create a nb of tables like this but each time this X will change.

What do you mean by 'nb'?

nb is for number

That's what I thought. Why would you want to create multiple tables for the same entity? This is not only uneccessary, but will make management of the database almost impossible (not to mention make it almost impossible to get any kind of meaningful information back out of the database).

ok, i'll change my analysis may be..
thx Jenny..

..HarunYahya.com An inviation to the Truth..

You're welcome. Good Luck!

You can find more information on the Normal Forms in the Access FAQA Forum.

thx Jerry..