Date Related Portal Records

[Mary Ann]

I am not good at writing scripts and I need help. I have 3 tables. The first is Inventory which contains vehicle description and ID No. The second is MileageFuel Use. The fields are Vehicle ID No., Date, End Mileage, Destination, Purpose, Fuel Type, Gallons, and Cost. The third table is MileageFuel Report. It is set up as a portal which has the related fields from MileageFuel Use. The relationship is based on Vehicle ID. I want to be able to show the records from the MileageFule Use table for a specific time period (7/1/10 ...7/31/10) for a specific vehicle. Right now I can show all travel and purchases for a given vehicle, but cannot break it down by time period. What do I need to do?

[comment]

You need to add more predicates to your relationship - see:

http://fmforums.com/forum/showtopic.php?tid/216271/

BTW, I am not sure why you need the third table.