Filtering Records Based on Multiple Relationships

[wmugrad28]

The company I'm working with rents out equipment that they own (among other things). I have the company listed under the general customer list like everyone else for a number of reasons. Some of the pieces are CURRENTLY being rented. I have figured out how to display these in a portal dynamically. I'm trying to filter out these currently used equipment pieces from the total possible fleet. How can this be achieved?

Some of my table names are CE (for customer equipment) and Rental Log.

Greg

[wmugrad28]

The company I'm working with rents out equipment that they own (among other things). I have the company listed under the general customer list like everyone else for a number of reasons. Some of the pieces are CURRENTLY being rented. I have figured out how to display these in a portal dynamically. I'm trying to filter out these currently used equipment pieces from the total possible fleet. How can this be achieved?

Some of my table names are CE (for customer equipment) and Rental Log.

Greg

[wmugrad28]

The company I'm working with rents out equipment that they own (among other things). I have the company listed under the general customer list like everyone else for a number of reasons. Some of the pieces are CURRENTLY being rented. I have figured out how to display these in a portal dynamically. I'm trying to filter out these currently used equipment pieces from the total possible fleet. How can this be achieved?

Some of my table names are CE (for customer equipment) and Rental Log.

Greg

[RalphL]

Assuming you have an unique ID for each Item. Make a related value list of the items rented. Make a calculated field = "0

[RalphL]

Assuming you have an unique ID for each Item. Make a related value list of the items rented. Make a calculated field = "0

[RalphL]

Assuming you have an unique ID for each Item. Make a related value list of the items rented. Make a calculated field = "0