Hi All,

I have build a database for my medical practice.

The database has a main table called patients with all the patient details.

I have another table called photos, linked to the patients database through patientID.

I have a layout, drawing data from the patients table, with a portal drawing data from the photos table.

I want to place a button on the layout to import several pictures into the photos table at once.

I tried using a script with the "import records" command, to import from a folder, but FMP does not know where to import the data to....

I tried using the "Go to field" command to go to the container field of the photos table, but this does not seem to work.

I am sure I am missing something very simple, but I cannot figure this out.

Any help would be appreciated

Run the import step from the photos table. However the issue remains to identify which patient the photos belong to. It simplifies things enormously if all the imported photos belong to the same patient, in which case the script would look something like this (in pseudo code):

Start on the Patients TO:

remember the patient id

go to photo layout

import records

set the patient id in each imported record with the patient id

return to the patient layout.

In practice this would probably be done in a separate window so the current window isn't disturbed.