Hi Sarah,
I am not sure why you are thinking of repeating fields (sounds
Filemaker like.)
Aren't you talking about a many to many table relationship?
A product has a list of items. (a one to many relationship) but an
item can belong to many products ( a many to many relationship)
This would imply three tables; Product, Product-Item, Item
The Product table has;
product_name, product_id etc.
The item table just the raw item details;
name, item_id, qty_on_hand etc
The Product-item table has their relationship (i.e is the repeating
field).
So in your case this table could have the following fields;
product ID, Item ID, Number_used
Then each time a product is "made", you would look up the records in
the Product-item table to get a selection of rows from the Item table.
Step through each row of this selection (of the product_item) and for
each item deduct the "Number_used" value from the associated record in
the Item table.
Is this what you had in mind?
James Hale
ja...@thehales.id.au
Tel: +61 3 9386 2516
Fax: +61 3 9386 1387
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
