Sep 26 2004, 09:48 PM
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.
Sep 26 2004, 11:09 PM
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?
Sep 27 2004, 10:05 PM
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.
Sep 27 2004, 10:51 PM
What do you mean by 'nb'?
Oct 1 2004, 08:07 AM
nb is for number
Oct 1 2004, 09:21 AM
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).
Oct 1 2004, 09:10 PM
ok, i'll change my analysis may be..
..HarunYahya.com An inviation to the Truth..
Oct 1 2004, 10:31 PM
You're welcome. Good Luck!
You can find more information on the Normal Forms in the Access FAQA Forum.
Oct 4 2004, 07:04 AM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here