⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Dependent table



Virtuon

Virtuon
  • profile picture
  • Member

Posted 16 October 2014 - 07:36 AM

Hello there!

 

I have a question how to realize dependent table like as:

 

Table 'Stores': (Main table) with columns

ID, Name .... etc.

 

Table 'Schedule' (dependent) with columns:

id, Days, opentime, closetime, storeid

 

Many records may belong to one Store e.g.

id     Name

255  StoreA

256  StoreB

257  StoreN

etc.

--------------------------------------------------------

 

id  days            opentime         closetime      storeid

1   mon-friday   07.00                18.00            255

2   sat                09.00                16.00           255

3   mon-friday    06.00               17.00            256 etc.

 

 

 

 


Amit Shah

Amit Shah
  • profile picture
  • Member

Posted 16 October 2014 - 16:21 PM

please express.. what is your real requirement / purpose of the query like ?