Jump to content
  • 0

Why Join When Passing Parameters?



Hi, I'm making an app and one of its main uses is booking time.

Every Booking has Days, and every Day has Times, and every Time has Services.


I planned on sending the autoID from each of these tables to the next by passing parameters, so that Services at the end of this chain will have the ID of the Booking, Days, and Times.


My question is why should I JOIN these tables if I'm passing parameters? I can always create Views with joins for the purposes of the views. I think I'm missing something basic.


Second question, if I should join, which referential integrity checks should I apply?



Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...