unrelated relationships
In our app we have the primary set of tables and then some that I would call "supporting" tables. The issue is at the lowest level, I may have all the necessary data to build a relationship but it do...
Forum Discussion
I've done things similar to this and while not elegant, it works. The parsing I've done using the Part function. This means I have to break my textlist into many parts and check each part. The upside, it worked. The downside - you have to repeat the part function to be at least as many as the max number of parts possible in your string. This is practical up to a certain number, but if you will have over say 50 parts, starts to become impractical. I'm curious to know if you come up with a sleeker solution.
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------
Mike you are right. A simple loop would make life easier. While I'll have only one record with that matches an event, there are multiple possible values that have to be evaluated to extract the right date. Right now the max is 10 so thinking I can build for 30 for today. I can easily part our the original mutli-text into individual values but how do I loop through to evaluate each one to get match the right one? Any recommendations on how you did this?
------------------------------
David Berndt
------------------------------
------------------------------
David Berndt
------------------------------
