Why Join When Passing Parameters?

[aam82]

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?

 

thanks

[Jan]

Hello aam82,

 

I am not sure that I understand your question.

From my point of view, you can use Cascading elements and look up tables.