On 10/02/2007, at 7:25 am, Beverly Voth wrote:
Steve might be close, and I'd suggest that you *do* keep the
equipment in
one table but rather than using self-joins, use a join table.
Or you could take advantage of the fact that FileMaker allows
multiline key fields, and not worry about a separate join table (...
but along with the others, I'd definitely have equipment in one
table, with a field denoting equipment type).
--
Tim Mansour <[EMAIL PROTECTED]>
Neologica Print & Promotions (ABN 63 904 335 408)
159 Commonwealth Street Surry Hills NSW 2010
Sydney 02 9212 1789 Melbourne 03 9012 7441 Mobile 0405 500 846