adding line items via an X Y type grid ?

[bolla]

Hi All,

I'm tyring to find an elegant way to add line items via an X Y type grid.

Style No: 101

. Sm Med Lg

Blue 10 20 30

Red 45 23 18

Green 23 56 20

_______________________

Qty 78 99 68

This should produce line items;

101 blue sm 10

101 red sm 45

101 green sm 23

101 blue med 20 ...........etc

Please find attached one method which works.

The final version needs to have up to 8 sizes and 6 colours, maybe more.

Sometimes there are only say, two colours / one size.

Colours, sizes and quantities need to be dynamic or appear so.

Any thoughts?

FileMaker Version: 7

Platform: Windows 2000

grid input.zip

[Ender]

Assuming the purpose of putting the data into a second table is so you can get aggregate data later, this seems to be a good way to do it. I use a similar method with an 18x1 grid. The benefit is that you don't have to worry about generating records (like in a list.) Related records are created automatically when data is entered. The drawback is that it can be slow over a WAN, because of all the relationships.

[bolla]

The line items will need to be tracked once the style is finalised.

Hence the idea of generating them now rather than using a script or exports later.

It's just that with say 6 sizes and 8 colours I'm looking at 48 relationships.

I'm jumping from Vers. 4 to 7 so the mind shift is a bit startling.

Thanks for any suggestions.

Cheers, Bolla.

FileMaker Version: 7

Platform: Windows 2000

[Ender]

After sleeping on this, I remembered that my 18x1 grid of relationships is really an 18x3 grid. There are also many examples of calendars that use a relationship for each day slot, that's 6x7 I think. So having that many relationships on a layout is not unheard of. But like I said, it can be slow on a WAN.

I can't think of a better way that keeps the same simplicity of the grid layout.