Inventory problem

[reynir]

Hi.

Im trying to make an quality and inventory system for food manufacturer.

The workflow is as follows:

Reciving of raw material (lot no./date/prod.code/quantity/price)

Then some of the raw material is sent into production in period of some days. (I use two files, rec_raw_material and raw_material_in_prod), related by the lot no. I do this to track what raw material was used on each day of production.

The producer manufactures some products from this raw material which was sent into production, (I use three files, production (date, item numer) which is related to raw_material_in_prod by the date, production_items, (date, item number, quantity, etc.), which is related to production by item number and date, and line items (item number, price, etc.) which are related to production by item number.

Then I want to track what production goes on each pallet and at the same time decrease the amount of produced items in the production_items file, i.e. if I produce 100 items on day 1, and put 50 items on pallet 1 and 50 items on pallet 2, then the production left is 0. To do this I think I have to use another file i.e. pallets.fp5 related to production_items by date and item number, and prod_on_pallets, related to pallets by pallet number, to track what production was put on each pallet.

My problem is this: when I try to use portals based on above relationship I get error message from FileMaker which says that this relationship is not valid because it is based on a calculated field??

Make this some sense to you out there?

Best regards from Iceland.

[CobaltSky]

A relationship can certainly be based on a calculated field. What matters is that the field is able to be indexed.

Some types of calculated fields are not able to be indexed - eg where the formula includes one or more global fields or fields from related databases. You will therefore need to ensure that your files are structured so that all of the target key fields are able to be indexed (whether they are calculation fields or not).

'Source' key fields (ie those in the file within which the relationship is created) do not need to be indexed however.