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.