I am in the process of learning the ins and outs of Panorama X. I now feel pretty comfortable setting up and managing data sheets and forms. And I am starting to add some programming to those databases. However, I am having some trouble turning my preconceptions of how things should work into something that actually works with Panorama X.
I have two different databases that have information that is linked: a data sheet with names and addresses, and a data sheet with records, sometimes multiple records, that are connected by a shared key with individual name and address records. There is a form that displays the address information in Text Editor Objects (which is editable), and in a multicolumn Text List Object. I have linked the second data sheet to this form using Text Display Objects using the lookup( function. This works well.
What I have been unable to do, either because I do not know how or because it is not possible in Panorama X, is to edit the second data sheet in the same form that I am using to edit the first data sheet. Right now, I am assuming that it is not a good idea to edit a field in a Text Object that is currently programmed to lookup( that same field. In any case, I have not figured out how to link a Text Editor Object that is in the form of the first data sheet with a field from the second data sheet.
My next choice, one that I have seen used before, is to have multiple forms open, one for each data sheet. Whenever some editing needs to be done, the edits will take place in the appropriate form. I would just need to arrange the forms so that they could be viewed at the same time.
Any information that will provide further enlightenment to me will be appreciated.