First off, I'm sorry I couldn't get you a reply sooner. I see
you have found another way, which is good :-)
> I've sorted it.
>
> Firstly, I've done away with the status field. If an item's
> been issued or is
> still on order it does not have a location. I've therefore
> set up two
> loc
On Monday 19 April 2004 4:01 pm, Gary Stainburn wrote:
> On Monday 19 April 2004 3:06 pm, Stijn Vanroye wrote:
> > Gary wrote:
> > > Hi folks,
> > >
> > > here's a straight forward join that I simply can't get my head round.
> > >
> > > I've got
> > >
> > > consumables: cs_id, cs_make, cs_comm
