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

Reply via email to