21 posts in this topic
I have a portal with a long list of data. I have added two global fields so that the user can narrow down the results. I would like to do this real-time as they type into the global fields.
I have the filter function working close enough, but what I can't seem to figure out is how to refresh the portal. If I leave the layout and come back, the correct data shows up, but where's the "Refresh Portal" or "Filter Portal" function???
Thank you in advance,
Indexed References to Related Field - FAIL
By Dr. Evil
How can I filter a portal by a calculation field that references a related child table?
I want to filter portal by "Working" and "Complete" but relation fails since the sorting field can not be indexed.
For some insight, tables set up is
ParentProject > ChildAssignment
I have a ProjectTable self relationship built, and want to sort this portal by "Working" and "Complete".
I have a global field that user can choose filter portal by "working" or "complete"
The global field is related to a calculation field that looks at the AssignmentChildren.
So working with three key fields here...
1) ParentProjectTable > GlobalProjectFilterKeyField; User uses to select what to sort portal by.
2) ParentProjectTable > CalculationProjectStatusField; The calculation that looks at the AssignmentChildren's status, looks like this...
not Sum ( PRJ~asgn`all_sort::clc_status_flag); "Complete"; "Working"
3) ChildAssignmentTable > A boolean calculation that refers to a text status field, looks like this...
txt_status_work = "Complete" or
txt_status_work = "Canceled"; 0;1
This is a mess trying to explain, let me know if you are interested in helping me solve this delima and or if you have questions on clearing this up.
THANKS A HEAP for your time and help on this!!!
Accessing records from portal
I have a layout that contains a portal to another table. When I view the records in the main table in browse mode/table view I see all the fields OUTSIDE of the portal from the main layout, but the fields from INSIDE the portal only show the first record. For every one record of the main layout I get one record from the portal, even though there are many records in the portal for each record of the main layout.
It was suggested to try a new layout of the main table to show the fields I need from the portal, so that they are main fields in their own layout instead of a portal. I tried but this still only gives me the first record in the portal. How can I view all the records in the portal for a given record of the main layout? I can see them all in browse mode for the layout while they are in the portal but I can't add them ALL to a new layout, can't view just the portal in table view, and don't know how to access them for formulas and finds.
When I tried to make a new layout for just the portal using the new layout wizard, it asks which table I want to use fields from. My portal is in the "Safety Clearances" table and the portal itself is not a choice, so I chose the Safety Clearances one. Then I get a list of fields to add to the label, but none of the fields from the portal are there, just the fields from the main table.
So I created a second layout using the various fields from different tables that the portal pulls from and it does create it's own record for the first record in the portal but that's it. It's the same as when I view the Safety Clearance layout in table view. All the fields in the main table are there, then there's the info from the first record in the portal. How do I get the rest of the portal records?
BTW, my 'about me' section has a description of the database this is for and I have an album of screen shots that may help explain the layouts.
Value List Filtered
By Andres Dominicci
I have a portal that holds a value list that it populates from another table. I would like to have the list to filtered if the value has been selected in the portal, so it doesn't repeat itself. For example If I have Machine 1, Machine 2, etc... and select Machine 2 in my first record in the portal when I create the second record it will take Machine 2 from the value list. My relationship is as follows.
Shift and machine table are already related to my transactions table in the relationship graph. My value list right now is being populated from the machine table.
Thanks guys in advance for your help.