You shouldn't be using labels for this to begin with. There should a Prices table with a RECORD for each price, with fields for:
This table should be related to your Tours table by matching on TourID, and to your ordering table as:
Orders::TourID = Prices::TourID
Orders:: Pax ≥ Prices::MinPax
Thank you - I understand - however my issue is that I do not want to have to type for each record the min number of guests and thus my idea of having editable labels that are pre-filled but editable in the event I need to change it
Can this be done so for one tour rather than having 10 records each record indicating the
Can I have for each tour a prebuilt grid that shows
Whereas I will enter the price - for each on the same record number for that tour but if I need to edit min 2 to say min 3 I can do so by editing min 2 to min 3 for this record only.
There are ways to automate data entry by scripts and auto-entered values.
The problem with your method that although the data is there, it's unusable. You won't be able to select a tour and the number of guests in one place, and lookup the correct price from your grid.
Thanks you are correct - My goal is actually not to use the data to select number of guests and then tour price populates. I have too many variables in my business whereas is not as straight forward as to just gettin the number of guests and the price
My goal is to have a depository record to enter prices for a tour, and while the data is not usable for calculation it is usable as a reference table - Makes sense?
So the record will be
Tour Name = Miami City tour
Then pre fill the following labels
So back to my question how do I make these fields editable for this particular tour in the event I want min 2 to read min3 for this tour?
You could use fields with auto-entered data as your labels: field Label1 auto-enters "Min 2", etc.
However, this is a "data graveyard". I am not sure what "a reference table" means and how it can be used. IMHO. you could just as well print the prices and pin them to a wall.