Jump to content

Databases relations

- - - - -

  • Please log in to reply
2 replies to this topic

#1
katerina

katerina

    Newbie

  • Members
  • Pip
  • 2 posts
Hi, I am creating relation between two datatables, by 2 columns: ID and expiry date. ID is not Null, it's known. But Expiry can be NULL for some rows in both tables.
Will relation work properly?

#2
WingedPanther

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Are you trying to design a query to get data, define a foreign key, or something else?
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#3
katerina

katerina

    Newbie

  • Members
  • Pip
  • 2 posts
No, I do it in my vb program. Just need to create relation with conditions I defined in previous message.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users