WIth the help I am getting here my app is slowly getting where I need it to get to start working
I need to be able to create a condition for a row to be referenced or not to the main table.
I have a lot of hotels and restaurants in their respective tables which are references to the main table of a tour. Each of these restaurants and hotels rows have a True/False column asking if this is the hotel or restaurant being currently used on the tour. I would like TRUE to be a condition for the reference to happen so that only the one I am currently using shows up when visualizing the main tour table.
Is this possible? I tried SHOWIF but I realized it is not what I was looking for, I need more something like a REFERENCEIF if there is such a thing.
Looking forward to learn enough to be helping other people soon…