2. ASPRunnerPro General questions
  3. Reminder Frame
This topic is locked

Reminder Frame

 		4/24/2010 06:20:02
ASPRunnerPro General questions
F
 Flavio author

I have two tables:
-planned_shifts

-shifts
Records have the same fields, one common field is "date".

I'd like the add and the edit page of shift table to have records with date = today from planned_shift table displayed, in order to help operator to fill data taken from planned_shift tables.

Could anyone help me, please?
Thank you in advance.
F
 		Flavio author 4/28/2010

I found a kind of solution by Making "future_shift" a detail table of the "shift " table, having as "masterkey" the "Date Field".

This way, in the edit page of the shift table i can display as details of the future_shift table the records having the same date of the date stored in the date field.

How can i make the details to be displayed in the add page too?

I'd be enough to have the records having the date = date() displayed.

Any help, please?
F.
Sergey Kornilov admin 4/28/2010

I'm not 100% sure I fully understand the question.
Just in case check this article that explains how to display data from other tables on Edit/Add/View:

http://xlinesoft.com/asprunnerpro/docs/show_data_from_master_table_on_detail_view_edit_add_page.htm