To number subgroups.

[Enigma20xx]

I have two tables:

1. Groups: records 00, 10, 20, 30 ....

2. Subgroups:

What I want to accomplish is to number related record in the subgroups table with the next number of it’s own group.

The first related record of group 00 will be 01, next 02

The first related record of group 30 will be 31, next 32 and so on.

The only calculation I am able to use is NumberGroup field + 1, and logically it works but only once , all related record have the same number.

Any help?

Thank you.

[comment]

For what purpose? The problem here is that the numbering can be either dynamic (i.e. depend on the current set/sort order) or permanent (i.e. not necessarily consecutive) - but never both.

[Enigma20xx]

The purpose is:

I have several expense groups and each of them has a few (less than 10) subgroups and I want to name them with its name and a number that tells me what main group it belongs to.

i.e.

group 0010

0011

0012

0013

group 0050

0051

0052

group 0100

0101

0102

0103

0104

As always thank you for your quick response.

[comment]

I don't think you have answered my question. For example, what would you expect to happen if you reassign a subgroup to another group?

In any case, I suggest you take a look at:

http://fmforums.com/forum/topic/73473-serial-increment-a-child-record/page__view__findpost__p__347655

[Enigma20xx]

I apologise if I can’t make my self understand, my english is not as good as remembered it .

I am not going to reassign a subgroup to another group. I just want to set them as stable data to use it to any customer.

I have already been working on LaRetta's demo and I think is more or less what I need, if you see any problem in working with that idea I’d appreciate your point of view.

Some subgroup names are coincident, that's why I’d like to add a prefix to see whose father is so I can chose the right one.

What idea would you suggest to name subgroups?

Thank you very much.

[comment]

I am not going to reassign a subgroup to another group.

Perhaps not - but it's still a good question to ask, in order to determine the suitable method. Perhaps you don't see it, but your question is not as simple as it would seem. It's one of those things that we do intuitively, but turn out to be very difficult to explain to a computer.

Some subgroup names are coincident, that's why I’d like to add a prefix to see whose father is so I can chose the right one.

If that is the real issue here, why not deal with it directly?

SubCat.zip

[Enigma20xx]

Thank you very much comment, as always, easy and clear.

I have made some changes (category field in Data layout, a new portal in categories) and they apparently work.

What I can’t make work properly is:

- clabel on Data layout and

- my new conditional VL

Thanks again comment.

SubCat - 2.zip

[comment]

The conditional value list is easy. Not sure what you want re "clabel on Data layout".

SubCat2a.zip

[Enigma20xx]

The "cLabel" field was ok, what it wasn’t was my relationship, that’s why didn’t work properly.

I think I wasn’t very far from the correct vl configuration, but on a wrong relationship, so, that’s nearly equal to nothing

I have a few questions:

- In the relationship graph I can see you place the tables and TOs in a specific manner. Is that because is your own way to do it or it is because is important in what side is the table or TO?

- In data layout, and having category selected its field doesn’t show anything until a subcategory is chosen. I solved it adding a Category TO related to Data by CatCode. Is that correct?

- How could I add a third level? i.e. Talking about cars Make-Model-Colour.

Thank you very much.

[comment]

- In the relationship graph I can see you place the tables and TOs in a specific manner. Is that because is your own way to do it or it is because is important in what side is the table or TO?

It's my own way. I think it's important, but Filemaker doesn't care.

- In data layout, and having category selected its field doesn’t show anything until a subcategory is chosen. I solved it adding a Category TO related to Data by CatCode. Is that correct?

Either that or use a pop-up menu instead of a drop-down list.

- How could I add a third level? i.e. Talking about cars Make-Model-Colour.

It's the same thing, extended. Note that the higher-level selections do not actually matter, other than to narrow down the subsequent choices. It's only the last selection that establishes the "true" relationship (this is why in my file you don't see the related category until you select a subcategory).

See also:

http://fmforums.com/forum/showpost.php?post/346499/

[LaRetta]

It's my own way. I think it's important, but Filemaker doesn't care.

Without hijacking this thread, can you explain why it is important to you, Michael? I personally still must place the child on the right side but that is just old habit when FM used to be one-way. If something is important to you then it is worth understanding.

[comment]

The RG is (also) a tool of communication - so it's important to have a language.

[Charity]

forgive me but

Is it silent visual language to represent the hierarchy? So Categories is above Sub-categories. That fits. Sub-categories to Data being equal ... not sure but okay. Then Sub-categories2 below Sub-categories because it is, well, an 'all' or a 'filter' or an auxiliary, or self-join. Maybe. If I stepped out of line please ignore Comment.

[comment]

I tend to place parent either above or to the left of child. It's not always possible - for example, in:

Customers -< Invoices -< LineItems >- Products

I prefer to place these core relationships on the same "line" and any auxiliary relationships to drop off that line.

I'd probably have a stricter and better formulated set of rules, if the RG were a more flexible tool.

[Enigma20xx]

I have read the tread http://fmforums.com/forum/showpost.php?post/346499/ and have been working with the sample file for a few days but I get stuck.

The hierarchy there is in between two tables and I’m trying to do it being 4 tables related.

I.e. Cars.

TableData

Make

Model

Colour

I attach a sample file based on comment’s one but this is as far as I can get.

Sample file is in Spanish but very easy to understand.

As always, thanks to all.

Tres Niveles VL.zip

[comment]

How about this way:

TresNivelesVL.zip

[Enigma20xx]

Sorry for the gap.

Dear comment,

Once again, incredible, your help is unpayable, not only you help me solving situations I can't but also you make my knowledge in FileMaker improve a lot.

Thank you very very much.

*Merry Christmas to everyone.

[Enigma20xx]

I know that for many people in here this could mean very few, but for me means a lot .

Working with comment's file I saw that if i.e. the DB is about cars

Cars

Makes

Models

Colours

the colours table gets full of many repetitions of the same colour so a join table is needed.

With my very few knowledge I gave it a try, and unexpectedly could make it work .

So here is the three level value list file, with a join table in between (spanish).

I hope there are no errors and this could help others with the same knowledge as mine, that is, begginer.

Thanks to all.

3 NivelesVLJOIN.zip