I am trying to develop a database for faculty appointments, with the
following Tables and Fields, among others:

Faculty Demographics (fields: LastName, FirstName, Birthdate etc.)
Faculty Appointments (fields: Rank, Department, Salary, Appt start
date, Appt. end date, etc.)
Appointment Process Tracking (fields: Date Received at Faculty
Affairs, Date Approved by Chair, Date Approved by Dean, etc.)

Each table above has it's corresponding layout.
FacultyID has been designated as the key to relate all three databases/
tables.

1. After creating a new Faculty Appointment record (or finding an
existing record) for a particular faculty member, I have a button
which let's me create a new Appointment Process Tracking record. The
button performs a script to go to the the Appointment Process Tracking
Layout, and create a New Record/request.

It let's me go to the Appointment Process Tracking Layout and create a
new record. However, it would be nice if I do not have to have to
type in the following information again: FirstName and LastName, Rank
and Appt Start and End Dates. This is very important, as we switch
from one layout to another, and it is cumbersome to have to re-type
all of these each time we go to another layout.(unless we specifically
want a new , clean record)

Is there a simple way to do this?

2. We also created a BACK button, which hopefully brings us back to
the previous layout we were on, with the previous information we were
looking at. However, I tried using Go to [original layout], and it
did not work. Is there some other way to do this? (Or a proper way
to do this, if I did not use the function correctly?)

I would appreciate your help on this.

Thank you!

1. Parse the Faculty Member ID to a variable (e.g. $$_FMID)
script: go appointment record layout, create new record, hard code the
variable held ID to the appointment record
Use an FM_ID (Appointments table) :: FM_ID (Faculty members table) to
place related fields on the Appointment layout to show FM_Details
(name,rank, start date...)

2. Return script
create a global field to hold the source layout g_origin
at the start of every nav script, parse the current layout number to the
global
create a Return script

return
Set Variable [ $$_origin; Value:Get ( LayoutNumber ) ]
Go to Layout [ uADMIN::g_origin ]
Set Field [ uADMIN::g_origin; $$_origin ]
Perform Script [ “window” ]

place a return button, with attached script on every layout, in the same
place
This allows you to go A>B>A>B... i.e jump back and forth

regards

Chris Brown


gpicache (AT) gmail (DOT) com wrote: