DAtabase in a database

[zorro]

Does someone know if it is possible to make a database linked to one record so that each record have the same database linked but with other values.

Because if i make a hyperlink to another database i have to make each time that i make a new record a new linked database.

Could someone help me PLS

THX

[zorro]

An example:

I have a database with patients. Each patient have different treatments ( that can be chosen with a lookup field see problem 2). I want to link a tabel/ collon to that pati

[LiveOak]

This is a very typical use of a database. If you define the relationshp based upon a "patient number" you can display the treatment records for just the selected patient in a portal based upon that relationship. If you set the portal to "allow creation of related records" you can add treatments (records in the related file) by typing in the last (blank) row of the portal.

-bd

[zorro]

Ok

[LiveOak]

Two techniques are needed. First single or multiple pieces of data can be passed from one file to another using global fields. To pass the treatement to the second file, set a global field in the first file to the selected treatment (call this field "gTreatment"). To access this global from the second (treatements?) file, you will need to create a calculated field in each file:

kOne (calculation, number, indexed) = 1

From the second file, create a relationship with the first file matching kOne <--> kOne. Now you can use this relationship to access the global field(s) in the first file. Why a global field? Because only a single fields exists per file, not one per record.

Next, create a script in the second file to create a new records and do a set field:

SetField(Treatment, FirstFile by kOne:: gTreatment)

Now create a script in the first file to copy the treatment to gTreatment and run the record creation script in the second file.

-bd

[-Queue-]

Relationships aren't necessary for accessing global fields between tables, and I believe a File Reference can access globals between files (don't quote me on that though). Even so, a constant calculation relationship shouldn't be necessary. That's what the Cartesian join (X) operator is for.

[LiveOak]

Oops! Thought it was a FM6 question.

-bd

[-Queue-]

Ah, makes sense then. That happens to me too, sometimes.