Jump to content

adding line items via an X Y type grid ?


bolla
 Share

This topic is 6698 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6698 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.