I have FORM A with field NAME1 - this will be an “entry” form. Now on FORM B, I need NAME1 to display with the data entered on FORM A. I’m confused how forms connect with the same data–is this a case of “shared” fields. And then from “FORM B” lookup “FORM A”'s data?? I’ve done some simple single form databases, but now need to be a little more creative. Any suggestions to get me started would be appreciated. Thanks, Diane
Subject: Getting started … sharing fields data
Actually in thinking about this you might only need one view. As an example, if you had a three state process (Request, Pending, Approved) and a “state” field to reflect that status then your view form formula would look something like below. So when the state changes so does the form being used to display the documents (after a save and document reopen).
@If(state=“”; “formRequest”;
@Contains(state; "Request"); "formRequest";
@Contains(state; "Pending"); "formPending";
"formApproved")
Subject: Getting started … sharing fields data
It’s not clear how your application is supposed to work but using different forms for the same data is very powerful.
Think of the document as just the data. If you select a document and open the properties box, then select the design tab, you’ll see the fields listed along with their values.
The form is just a way for your users to see the fields. There may be 10 fields of data in the document but your form may only show 5 of those fields.
Then with different views we can use different forms. Taking your example you could have View A and View B, with each one respectively using Form A and Form B. Both are using the same documents. So if you want NAME1 to be shown on Form B then you only need to add a field with that name. Pretty cool eh?
It almost sounds like you’re thinking of two different documents here which you might not need given the above.
HTH
Subject: RE: Getting started … sharing fields data
Michael, You are right, I need only one document to enter the info, but need it displayed in a different “view”. Thanks for your post on this, I believe it is the view that I need to be working with.
Diane