I just want to be able to pop-up a list of, say, Names-in-Datasheet-A when I’m entering records in Datasheets B or C (pop-up or equivalent, such as “Clairvoyantly” auto-fill, use “Post” statement with mode “updateadd”, etc.). The example is specific, but is meant to be basic enough to apply to many standard data situations (so substitute any dataset for “photos” - I just happen to do a lot of work with images,and so the fields in my example hold storage addresses for images).Īt this point, that the link is dynamic is is secondary. The goal (of course) is to be able to build forms that show Individuals (Datasheet A) and (in my example) photos of them (Datasheet B), and photos by them (Datasheet C).
Panorama x relational database update#
There are 1-to-many records in Datasheet C for each individual in Datasheet A.Īt it’s simplest (afaict) I want to be able to add records to Datasheets B & C and include a field in common with Datasheet A (e.g.: “UniqKey”) that will update any time the field-in-common in Datasheet A is changed. Datasheet C stores addresses for image files taken by those individuals.There are 0-to-many records in Datasheet B for each individual in Datasheet A. Datasheet B stores addresses for image files of those individuals.I want (I am struggling mightily in the eddies of ignorance) to, from Datasheet B, select the UniqKey from Datasheet A, and have it update and remain linked when I change the text of the UniqKey in Datasheet A. I have several databases that are linked by a common field (let’s just call this “UniqKey”). This is exactly what I want to do (as far as my understanding extends, which is about a handbreadth past my eyelashes). That is another area you should study.If you want a live relationship, where if you relate to data in another file even if it changes, you should look it up in a procedure in a form object In particular, if you have a lot of data items which, for instance, are associated with each language, they could be put into arrays or dictionaries and stored as Choices within a single database, and you would only have to enter them and store them once. Keep in mind that with Panorama’s efficient use of storage, some things that you may have done with relations could more easily be done without them.
Panorama x relational database how to#
You should study the help files, with particular emphasis on lookups and arrays, to see how to build your own relationships. There is a lot of flexibility, but that flexibility requires a lot of choices to be made and adds complexity.
Alternatively, they may be used in form elements to display the data, without actually saving it to that file. Lookup or array search functions can be used to copy data from one file into fields in another file, as you described. How that is organized depends on how you will input, search, and otherwise use the data. Or they could be in dictionaries, which are specific types of arrays. Or you could arrange the information in arrays, which are like miniature tables which can be stored in a field in a database. You could have several different files which correspond to tables.
In Panorama, there are several ways to do this. Have I understood correctly? If so, what is the most straightforward way to emulate such a situation in Panorama X?
If I understand correctly, Panorama X uses a separate file for each table, and data are copied from table to table rather that data in one table being viewed in another. A language_ID in each record relates the ‘Words’ table to a ‘Languages’ table, so that several field in each record in the ‘Words’ table show info that is stored in the ‘Languages’ table. These include the name of the language the word belongs to, the language group the language belongs to, etc Since these bits of info are repetitive (because many words belong to the same language) they are stored in a ‘Languages’ table. Within each record are fields that contain various pieces of info. So I have a database with a ‘Words’ table that contains words from many languages, each word in its own record. Filemaker stores data in ‘tables’, such that one can set up one table with fields that show data from another table/other tables. I am new to Panorama, having previously used database systems such as FileMaker Pro.
0 kommentar(er)
