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
