VB og Access2000

Hvad er 'kardinaliteter' ???

kardinalitet er udtrykket for forholdet mellem tabeller. f.eks. en til mange

reds2001 is it possible for us to see the code you are using to create the tables etc.?

sure thing terry:

strSQL = "CREATE TABLE Exp_Table(" + _
        "Fluid_ID long CONSTRAINT FluidID_Req NOT NULL," + _
        "IOIL integer2," + _
        "MwAdj integer2," + _
        "DensAdj integer2," + _
        "NSatSets integer2," + _
        "NSepSets integer2," + _
        "NDlSets integer2," + _
        "NCmeSets integer2," + _
        "NCvdSets integer2," + _
        "NVisSets integer2," + _
        "NSwellSets integer2," + _
        "CONSTRAINT ExpTableConstraint UNIQUE(Fluid_ID))"

    Conn.Execute strSQL
   
    strSQL = "ALTER TABLE Exp_Table ADD CONSTRAINT FKFluidExp FOREIGN KEY (Fluid_ID) REFERENCES Fluid_Table(Fluid_ID) ON UPDATE CASCADE ON DELETE CASCADE"
    Conn.Execute strSQL
   
    strSQL = "ALTER TABLE Exp_Table ADD CONSTRAINT ExpUnique UNIQUE(Fluid_ID)"
    Conn.Execute strSQL

reds2001 am I right in saying that we are talking either and SQL Server backend or maybe MSDE?

Can I also have the layout of Fluid_Table table?

what is CONSTRAINT ExpUnique for, isnt CONSTRAINT ExpTableConstraint the same?

Hi terry,as a matter of fact it is just a simpl access2000 file.
By the way the two constraints are the same. Even if i remove one of them I end up in the same situation. I'm not at work right now so I have to post it tomorrow.

OK, if you can send it tomorrow then I'll take a look. I must admit that I havent normally created tables through code, so I am not sure what to expect. You may be needing a PRIMARY KEY constraint which is NOT the same as a unique key!

reds2001, hows things going here?

resd2001 are you there?

Hej Terry, undskyld forsinkelsen. Jeg har været i kontakt med Microsoft Support med det her problem og det viser sig at forklaringen på det hele er at systemtabellerne ikke er opdateret til at vise det rigtige view. Relationerne er ellers gode nok.