Ugh, I knew I was going to wind up asking too many questions, but which
side is considered the "parent" side?

jbpollock (AT) gmail (DOT) com wrote:

Michael Myett

That seems to have done it! I won't even bother wondering why it
seemed to sort of work before with the wrong boxes checked.

Followup question: in terms of the incrementation of the ProjectID
field, I noticed that all the tasks associated with one record have the
same ProjectID (which I expected), but the next record's ProjectID
isn't an increase of 1; it's usually an increase of 2 or 3. I thought
perhaps the numeric increase was related to how many tasks I created,
but that doesn't seem to be the case...

jbpollock (AT) gmail (DOT) com wrote:
as an auto-enter serial number. This should be a plain text field.

Michael Myett

Last question (I promise!): how would I create a separate layout that
would display Institution, TaskType, TaskDescription, and ProjectID for
each task created in the other layout? I want to make sure that the
info is properly getting into the Tasks table... I tried just creating
a layout that uses data from the Tasks table and displays these fields
(with the "institution" field coming from NOAA 2) but that didn't seem
to work.

Thanks again for your quick and patient replies!

Cheers,
John

Create a new layout showing records from table NOAA2

Put the the fields you need on it

ProjectID form NOAA2 (current table)
Tasks::Institution (from tasks table)
Tasks::TaskType
Tasks::Taskdescription

And it should work as expected.

Then one more hint. Currently your ProjectID is Auto-Entered and can't
modify. But you also should set it to unique.

And i'm intrigued by the field one < calculated , number ; 1 > What is it's
purpose? Why a calculation to a constant one? And not in use anywhere else..
These thing make me wonder....

Ursus

<jbpollock (AT) gmail (DOT) com> schreef in bericht
news:1132349882.125699.126430 (AT) g44g2000cwa (DOT) googlegroups.com...

Ursus,

Thanks much! That layout worked a treat. As to your question:

That was a leftover from a previous (unsuccessful) attempt to create a
portal that
would allow for multiple projects, each with multiple tasks, to be
associated with each institution. The directions I had been following
for such a setup specified creating such a field in both tables and
creating a cross-table association based on that field (which I didn't
really understand). I wasn't able to get the multi-project/multi-task
functionality working properly, and so gave up on it because seemed too
complicated a question to pose here (or rather, one that would involve
having to ask for too much help). I just couldn't wrap my mind around
how to design such a thing (again, being still something of a newbie),
and I couldn't find any tutorial on the web that would explain how to
do it in FM 8.

In any case, I actually deleted that "One" field as part of my cleanup
process, but didn't do so until after posting the copy to the web that
you saw.

Cheers,
John