many thanks - that fixed it :)
Just one more question - I have a portal that will also now show those that
are in and are removed at the same time, is there a way to change the text
colour of the record displayed in the portal for the removed items.
That being is if removed = yes display that record with grey text or
background grey or something that will show in a list those that are listed
"John Weinshel" <johndatagrace.biz> wrote in message
news:vh44a9l4f13ef7news.supernews.com...If> Say the portal displays a relationship that uses the Box_ID field as the
> match field on both sides. In the child file (items in the box), add two
> fields: 'In', a number field defined to auto enter with a value of 1, and
> 'BoxID_In', a stored calculation, returning text, defined as:
> Box_ID & " " & In
> ...so, an item whose Box_ID is '4578' and is still in the box would return
> 4578 1. In the parent file ('Boxes'), create a similar text calc
> ('BoxID_1'--need not be stored) defined as:
> Box_ID & " 1"
> ...and create a portal that displays a relationship ('Full') from BoxID_1
> to BoxID_In. You can display In in the portal row, formatted with a single
> checkbox (using a value list with 1 as the only value). When an item's In
> field is toggled off, it will fall out of the relationship.
> You can use the Aggregate functions (Sum and Count) across the two
> relationships to count items and boxes. Thus:
> ...will return a count of items, as will, in this case, Count(Full::In).is> there is a quantity field, i.e., 6 of an item, then:
> ...will return that total.
> John Weinshel
> Vashon Island, WA
> (206) 463-1634
> Associate Member, Filemaker Solutions Alliance
> "gwmbox" <gregatworkNOSPAMPLEASEhotmail.com> wrote in message
> news:3f12092c$1quokka.wn.com.au...> > Hi
> > Fm Dev 5.5v1 on Win Xp Pro
> > I have two related files, one is the details about a box and the otherremoved,> box> > the items within the box - they are seperate as we track the box and the
> > contents seperately.
> > Anyway we have the ability to remove items from a box and when these are
> > done they are marked removed which is fine (they however remain on the
> > system for tracking and are still linked to the box, but how do I in the> > view in the portal view only display the items that have not been> are> > i.e. to not list the items removed.
> > Also is it possible to do a count on portal items - i.e. how many items> box> > in the box and if it reaches zero then we can identify on the system the>> > is empty and then allow us to mark the box as removed.
> > Thanks
> > Greg