Automatically enter fields(ie:name, rank etc) as we switch from one layout to another

#1

Rep-posting: I feel that my original subject was not descriptive of
what I need......

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!

#2

In article
<1180738426.268379.73790 (AT) x35g2000prf (DOT) googlegroups.com>gpicache (AT) gmail (DOT) co
m wrote:

Quote:

Rep-posting: I feel that my original subject was not descriptive
ofwhat I need......

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

Faculty Demographics (fields: LastName, FirstName, Birthdate etc.)
Faculty Appointments (fields: Rank, Department, Salary, Appt
startdate, Appt. end date, etc.)
Appointment Process Tracking (fields: Date Received at
FacultyAffairs, 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.
Thebutton 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-typeall 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?

You're duplicating only because you choose to.

You say you have the tables related via FacultyID. If you want to
display the member's name (or any other data from another table) on
Appointment Process Tracking, you simply place the related field on
that layout.

Quote:

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
wayto do this, if I did not use the function correctly?)

There's no need to switch layouts, either.

On the Demographics layout, place a portal to to Appointment Process
table with all of the fields in which you will be making entries.
Define the relationship to allow creation of records in the latter.
Whhen you're on a member's Demographic record, you go to the portal
and make the entry, and the new record is automatically created in the
Appointments Process table. No muss, no fuss, no worry about what
layout you get back to.
Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo

#3

On Jun 1, 4:27 pm, Matt WIlls <I... (AT) Witz (DOT) End> wrote:

Quote:

In article
1180738426.268379.73... (AT) x35g2000prf (DOT) googlegroups.com>gpica... (AT) gmail (DOT) co

m wrote:
Rep-posting: I feel that my original subject was not descriptive
ofwhat I need......

I am trying to develop a database for faculty appointments, with
thefollowing Tables andFields, among others:

Faculty Demographics (fields: LastName, FirstName, Birthdate etc.)
Faculty Appointments (fields: Rank, Department, Salary, Appt
startdate, Appt. end date, etc.)
Appointment Process Tracking (fields: Date Received at
FacultyAffairs, 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.
Thebutton 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-typeall 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?

You're duplicating only because you choose to.

You say you have the tables related via FacultyID. If you want to
display the member's name (or any other data from another table) on
Appointment Process Tracking, you simply place the related field on
that layout.

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
wayto do this, if I did not use the function correctly?)

There's no need to switch layouts, either.

On the Demographics layout, place a portal to to Appointment Process
table with all of thefieldsin which you will be making entries.
Define the relationship to allow creation of records in the latter.
Whhen you're on a member's Demographic record, you go to the portal
and make the entry, and the new record isautomaticallycreated in the
Appointments Process table. No muss, no fuss, no worry about what
layout you get back to.
Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it athttp://www.malcom-mac.com/nemo- Hide quoted text -

- Show quoted text -

Thank you so much, I will work on this based on your recommendation!

GP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Automatically enter fields(ie:name, rank etc) as we switch from one layout to another

comp.databases.filemaker comp.databases.filemaker

Automatically enter fields(ie:name, rank etc) as we switch from one layout to another - 06-01-2007 , 05:53 PM

Re: Automatically enter fields(ie:name, rank etc) as we switch from one layout to another - 06-01-2007 , 06:27 PM

Re: Automatically enter fields(ie:name, rank etc) as we switch from one layout to another - 06-07-2007 , 04:20 PM