Hi there,

I hope this topic is in the correct section - apologies if it isn't!

I'm pretty new to FileMaker, and have just been chucked into the deep end.

I'm working on a multi-user solution, trying to implement the following...

'Table A' is list of Products.

'Table B' is a list of ProductOptions.

'Table C' has two fields ('Table A ID' and 'Table B ID') and is used to define which ProductOptions are available in each Product. Any given ProductOption can be available in multiple Products.

I'm trying to create a Layout which lists every ProductOption in 'Table B', and also (using a portal) the ProductOptions currently available for a given Product.

My Layout's main table is 'Table B'. I have a portal in the Header which shows the the ProductOptions for my currently selected Product. The ID of the current Product is being stored in a Global Field within 'Table B'.

This is working. My problem is basically that I need this to work in a multi-user environment, which means I can't use a Global Field!

I hope this is enough information to go on.

Cheers,

Matt

Why? A global is session specific...