I enter two types of information on two separate forms with the only the "casenumber" field being shared on both forms. In a view I would like to merge the different sources of information to a single row. What is the syntax and can it be done.
As far as Notes is concerned, it's simply a matter of indicating the field to be represented in the column of the view. Create a column, then set its value to that of whichever field you want. In terms of selectively bringing two groups of data together, it's best to create separate views for each, then a third view that programmatically combines elements of the two. For example, you might use DbLookup to pull a value (whose first column, say, matches a particular 'casenumber') from one view. then do the same for the other view. The problem with this approach is that it's computationally expensive. You're better off placing all of the columns you want in one view (with 'casenumber' as the first column), categorizing, and formulaically hiding columns that you don't want displayed. "One fish, two fish,
Unfortunately, you can't use Db commands in views. What I'm suggesting is to create a form with fields that do the DbLookup's for the two views, then create a third view that pulls in values from this form.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.