Hi all

I am trying to upgrade how welders continuity log file by using a portal instead of a list view layout but I came across a problem on what field to base the relationship. Here a little history on how the it works. A users press a buttom and a serach range of dates are created automatically bu using the Get(Currentdate) and the Get(currentdate)+30. This creates the date rnage to search. Then the welders that needs to be requlification in between this dates are displayed in a list view layout.

I would like to create a portal to perform this function but I am at a lost on how to create the relationship to displayed the records because the records do not have any thing the same.

[color:orange]The ID number would be different

Their stamp numbers are different

Their welding processes are different

Last day welded is different

the expiration day would be different

[color:blue]The only thing that these records have in common is that there expiration date falls in between the search date range.

any ideas on that to base the relationship on would be greatly appreciated.

Example

Welder one may have welded with the GTAW process and his expiration date is 1/10/2009

Welder two may have welded with the FCAW process and his expiration date is 1/12/2009

Both of these would need to be displayed in the portal at the same time.

Hope I explain it well up.

Thanks

Lionel

Use Expiration Date as the key in the related table and add 2 unstored calculation fields DateToday = Get (CurrentDate) and Date30 = Get (CurrentDate) + 30.

Relationship is:

DateToday ≤ Expiration Date

AND

Date30 ≥ Expiration Date

thanks for help

Lionel