Referencing fields in other records...

[zschenkel]

Ok, rookie question here. I'm new to FileMaker, I've been using it for about 2 weeks. I'm working on a solution that was created for the company I'm working for by an outside consultant.

What I need to do is organize the parts list for products. I want the products to be sorted into a list so that the end level parts are listed, with all the components of each part indented below them. Sub components of components are also indented below the respective component they are part of.

Each product has an End Part field that defines if the given part is an end level product, as well as a parent field, that shows what part it is a component of.

There is also an item level field so that end level parts (with no indenting) will be item level 1, the components making up end level parts will be level 2, components of those components are level 3 and so on.

Conditional formatting is used so that the appropriate amount of extra spaces are placed before the part numbers of a given level.

What I've been trying to figure out is how to set this item level field automatically, so that it will see what the item level of it's parent part is, then simply add 1 to that. Basically by referencing the item level field in a different record, which I cannot find how to do.

Any help would be greatly appreciated...

[eos]

For me it's not clear which / how many tables you are using, i.e. where these different fields reside.

Could you post your database (a clone might do), or at least a screenshot of how it's looking now?