Can you give an example of the data being searched?
What fields record when the item was checked out and when it is due to be returned?
Can you give an example of the search you want to perform?
Do you want to find all items checked out over a given range of dates or all items checked out on a specific date?
I have a T O "DailyPull" and DailyPull_Lineitems" that I create a PullOrder in Daily Pull based on the date and Select Items from my inventory portal.
This relates to a "Universal Report" which I use the DailyPull Items from. The Daily Pull Date is the global link that makes items available to the Universal report.
An Example: I create a Universal Report from a Universal TO which has a Daily Pull portal that when the daily Pull global date is changed the items change. Ideally I would like a span of days.
Yes, but how do you know an item previously pulled will not be available the next day due to being an item that "can be used for 2 or 3 days"?
Do you assume that all items are returned on time or do you check them back into inventory?
The items do not come back into the DP inventory. The universal report is to track only when items are presented to a customer. The shelf life of the product is maximum 3 days.
You could use a calculation in the child record to create a return delimited list of dates, so if you want it to appear for 3 days, you can set a date when the item is placed into inventory and add 2 additional dates to this calculation. Then use the calc in the relationship, so as long as the date in the global field matches one of the dates you will get your result.
I'm afraid that I can't quit picture what you are trying to do.
Do you want to enter a date such as march 6, 2012 and get a list of all items "pulled" on that date? Can't be that simple.
- All items "pulled from march 6 through 9?
- All items pulled on March 6, but include items pulled on March 5 if they have a 2 day shelf life and also those pulled on March 4 if they have a 3 day shelf life?
- Options 1 and 2 combined?
Yes its probably simpiler than I am explaining. I thought if I could just put in a span of time to show the products such as March 6th through March 9 would be prefect. As I tried to explain earlier putting in a date range of 3/6/2o12...3/9/2o12 doesn't the solution.
Do you want to enter a date such as march 6, 2012 and get a list of all items "pulled" on that date? Can't be that simple. This is what I have now but is limited to only one day.
Sorry but that didn't answer my questions. Please read the list of options 1-3 and tell my what you want.
They can all be done but I still don't know what you want.
yes #2 includes the 3 day shelf life is perfect
Add a field that records the shelf life in days. Given what we have here, that would be the number 1, 2 or 3.
Define a calculation field, DateDue defined to return date as:
DatePulled + ShelfLife
Now specify your search criteria by entering the desired date into both fields with inequality operators:
Put: <3/8/2012 into DatePulled and put >3/8/2012 into the DateDue field.
As a script using today's date, it would look like this:
enter Find mode
Set Field [YourTable::DatePulled ; "≤" & Get ( CurrentDate ) ]
Set Field [YourTable::DateDue ; "≥" & get ( CurrentDate ) ]
Set Error Capture [on]
Perform Find 
For using a date specified by the user, replace Get ( CurrentDate ) with a reference to a global date field where the user selected a date.
Well I have really really toiled with this one I have to say. I have not been able to get a relationship between the Daily Pull Portal and my UCR form to work. The script information provided does find the date span with the shelf life for the Daily Pull records now I need a common Global field that searches the data. Currently I have the GlobalDate field as my relationship Universal:gseachfield X DailyPull Date will show all my portal information and I can change the selection by the date. My Example: I create my Universal form on March 12th. on the left side is my portal of items to choose from I can change the date to the 11th, 7th a month ago and it shows me what my daily pull records were for that day.
I have tried using a "DateSpan" calculation that matches in both the UCR report and DailyPull Table as a matching field 3/9/2012...3/12/2012 and has not worked? I feel a bit lost on this one. I will use this on an ipad so having to use the calendar to do a span is impractical although I know I can use two date fields and have calculate although still very cumbersome. I am probably missing a very simple solution. Thanks for the guidance.
For a relationship, set it up this way (assuming DateDue is Date + shelfLife - 1)
UNIV::g_searchDate > DailyPUll_4Select::Date AND
UNIV::g_SearchDate < DailyPull_4Select::DateDue AND
UNIV::gSupplierCode = DailyPull_4Select::Code_PB_pk
I've gotten so lost in this journey I needed to step away unfortunately still lost. Attached are my pictures of my Daily Pull and Universal. I've become very confused Im sure you can clarify when seeing. What I did: Step one. In the DailyPull T/O I made a "shelf life" field with +3 days and a 'Date_Opened' field the creation date. 2. Created a "DateSpan" calc of DateOpened + ShelfLife. 3. In the DailyPull LineItems created a CalcField "DateSpan" that auto enters the DP_DateSpan. 4 Using the Universal T/O created a "DateCalled" creation date and a ShelfLife Field that is calc -3 days., 5." Date_Open" = Date_Called - ShelfLife 6. DateSpan = Date_Opened & "..." & Date_Called. Thank you for your time.
Not sure how to load multiple will be adding additional. this is the Daily Portal