Arrange order of field choices
Hello. I have a table containing different projects with each having 12 months and a corresponding value for each month. Then I set up this lookup field Month which is a reference proxy from that tabl...
Forum Discussion
Isabel,
You need a Record Picker report that orders the data from the Parent Field.
1) Assuming that you added the records to the Months table sequentially, you just need to create a report that sorts from low to high on Record ID# so that your users will see them January to December.
2) if the Record ID# is not in order, then you should add another Text field to the Months table. Call it Sequence or some other name which makes sense to control the order of the records. Then give January the value "A" and continue to December. Now your Record Picker report should be sorted on Sequence from Low to High.
In both of these examples, only put the name of the month in the report. Do not include the Record ID# or the new field.
Last, on your form specify that the Record Picker report is to be used. Here is picture specifying an Embedded report
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
You need a Record Picker report that orders the data from the Parent Field.
1) Assuming that you added the records to the Months table sequentially, you just need to create a report that sorts from low to high on Record ID# so that your users will see them January to December.
2) if the Record ID# is not in order, then you should add another Text field to the Months table. Call it Sequence or some other name which makes sense to control the order of the records. Then give January the value "A" and continue to December. Now your Record Picker report should be sorted on Sequence from Low to High.
In both of these examples, only put the name of the month in the report. Do not include the Record ID# or the new field.
Last, on your form specify that the Record Picker report is to be used. Here is picture specifying an Embedded report
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
- Brilliant! Thank you so much for the help.
------------------------------
Ma. Isabel Gumanid
------------------------------
