2. ASPRunnerPro General questions
  3. Copy feature and dependent drop-down boxes
This topic is locked

Copy feature and dependent drop-down boxes

 		12/11/2006 12:54:02
ASPRunnerPro General questions
B
 berkeleyjw author

I have a table that has several related drop-down boxes.
Field 2 is dependent on field 1. (1 -> 2)
Field 5 is dependent on field 4, and field 4 is dependent on field 3. (3 -> 4 -> 5)
When I use the Copy feature, the new record only has field 1 and field 3 displayed.
The other drop-down boxes are blank and will not allow for any selection.
But, if I change the value of field 1 and then change it back to the original value, I am then able to select a chioce for field 2.
The same thing happens for the field 3-4-5 relationship.
This seems to defeat the purpose of copying to a new record.
Has anyone else run into this problem? Please advise. Thanks.
B
 		berkeleyjw author 12/12/2006

THis seems to be a larger problem.

I have another table that has three drop-down boxes that are not dependent on each other at all. When I use EDIT or COPY, all three fields are blank (says "Please Select") and I have to select the values all over again. Please advise. There are now several instances in the same project where this is happening.
Sergey Kornilov admin 12/12/2006

Jim,
could you post this to Demo Account and send me a link? Also I need to know what table/fields to look for.
B
 		berkeleyjw author 12/13/2006

http://demo.asprunner.net/jw%5Fberkeleycol...verSRM/menu.asp
Use test/test as login
Set Up Courses - Schedule of Classes. On first record, drill down to Section meetings. On the list you wil see that Begin and End times are there. When you click COPY or EDIT, they disappear.
Student Enrollment. Look at list. Notice that Academic Career, Term, Term Session, and Class Section are all populated.

On first record, click COPY. Now, career, term session, and class section are gone. (Note: the EDIT botton shows some display-only copies of the fields since you cannot edit those).
Any assistance will be greatly appreciated. I have to get this working before January 2007.
PS: It seems some of the views did not upload/build properly (SQL Server).
Sergey Kornilov admin 12/14/2006

Jim,
I see what's happening.
You cannot use Datetime field as a link field in dropdown box. In ASPRunnerPro for validation purposes have to transform date fields into yyyy-mm-dd hh:mm format which means it won't match lookup table format mm\dd\yyyy hh:mm:ss.xxx.
You have two options here:

  1. Use a numeric field (ID) as alink between the main table and lookup table.
  2. Instead of datetime fields in lookup table use text fields. Anyway you use time portion only.
    Regarding some views not transferred to Demo Account - ASPRunnerPro only transfers tables and views that are included into the project.
B
 		berkeleyjw author 12/14/2006

Sergey,
This still does not explain why it is happening in my second instance:
Student Enrollment. Look at list. Notice that Academic Career, Term, Term Session, and Class Section are all populated.

On first record, click COPY. Now, career, term session, and class section are gone. (Note: the EDIT botton shows some display-only copies of the fields since you cannot edit those).
These fields are not date/time fields. In this case, the academic career list is dependent on the person (based on an underlying view). Likewise, class section is dependent on term session, and term session is dependent on term.
Please advise. Thanks.
Sergey Kornilov admin 12/14/2006

Jim,
for support questions like this one please contact me directly.