I'm sure I haven't used the correct terminology in my question, but I have recently been introduced to the global field within filemaker pro as the 'query' substitute for access. But I'm having trouble trying to understand how it works. To describe:
I have a supplier who supplies a changing source of seasonal vegetables. I have created a suppliers table which holds all the relevant suppliers details and also a produce table which stores the details for each vegetable these suppliers supply. In this produce table there is a produce id, a produce name, a unit cost (often changing and in need of updating) and a list value (yes or no) that states whether a vegetable is in season or not.
What I want is to be able to see within the suppliers record a list of vegetables they provide that are in season, and another list of vegetables they supply that are not yet in season. When a vegetable then becomes in season I want to be able to click a button labelled 'in season' and the vegetable then populates the 'in season vegetable list'. Likewise when a vegetable moves out of season, I want to press a button labelled 'out of season' and the vegetable populates the 'out of season vegetable list'.
These lists I want to view as tabs within the suppliers record.
I have previously been shown a method of doing something very similar using the global field within filemaker but though I have tried to emulate it as a solution to this problem I simply can't get it to work! Is there anyone who can help...(Lesouef you out there?)