referential integrity in ms-access

  • i have some child tables, and master tables, i want when a delete record in master table, child record should also get deleted, is there any feature for that in ms-access?, i know it is there, but could not find that..

    i making a jobsite http://www.jobsdhundo.com

    for it professionals, they register and post there skillsets,

    which are stored in a child table, i want when they delete there records there skillset should also get deleted

     

    thanks in advance

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • MS-Access? You just set up 'Relationships'. Perhaps you'd get better answers in an MS-Access forum.

    Good luck for running a website on an MS-Access database. Not something I'd ever do.

    Rob Farley
    LobsterPot Solutions & Adelaide SQL Server User Group
    Company: http://www.lobsterpot.com.au
    Blog: http://blogs.lobsterpot.com.au

  • Yes there is. Open the Relationships Window and right click on the foreign key LINE and select "Cascade Delete Related Records "

    hth

     


    * Noel

  • thanks, i thought so, but i wasn't sure, whether it will work,

    anybody knows about webservices

    i have a website, which is in asp, i want to extract/send data to website,

    i will be making client in vb.net,

    any idea how to get started??

    i know how it is done in asp & vb by user xmlhttp object,

    but iam planing to do it in vb.net, to gain experince in vb.net

    thanks, any solutions pls tell

     

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply