Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
1to1 relation form

คำตอบ 1to1 relation form

  • Monday, February 13, 2012 11:44 PM
     
     
    Sign In to Vote
    0
    i have 3 tables each related in 1 to many relation and i have 23 tables each realted in 1 to 1 relation to each of the first 3 tables. how can i do a form for these 23 tables?
     

All Replies

  • Tuesday, February 14, 2012 2:42 AM
    Answerer
     
     
    Sign In to Vote
    1
    What do  you mean by "do a form for these 23 tables"? Every table (those 23) should have a key referenced to the those three tables

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

     
  • Tuesday, February 14, 2012 5:51 AM
     
     Answered
    Sign In to Vote
    1

    Hi,

    In 23 tables you need foreign key for each of the three table. (PK and FK) and as you mentioned your relation is 1 to 1. I guess if you use a unique and no null constiants or each reference key on the 23 tables.

    If you want to create from in VB or C# you can use views to query your data or SP to query and DML your data.

    I hope this is helpful.

    Elmozamil Elamir

    MyBlog

    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid
    http://elmozamil.blogspot.com