Ok, so I have been up since early this morning actually focusing on 
Filemaker, and the database I have been thinking about building since I 
got my mac (a workout log)... Call me a procrastinator..

I'm beginning to see why it is considered so user friendly, as quite a 
few things have clicked.

too many coffees by now though...getting frustrated with this one:

File one = Main
pkeyUniquedayID
date
Journal

file two = cardiomain
pkeycardioMainID
fkeyUniquedayID
activity
location
Workout Notes

(I plan to hve some summary fields related to the detail file below)

file three = cardioDetail
pkeycardiodetailID
fkeycardiomainID
duration
distance
pace
etc....

I have two layouts "Home' & "Cardio"

cardio contains the cardiomain fields, and a portal to cardio detail, 
which can have many related records to cardiomain.

I want a script that will create a related cardiomain record, setting 
the fkeyuniquedayId, and create related detail records in the portal, so 
that when i add a new record, it sets the fkeycardiomainID to the 
related record in cardiomain.

I can't thank about it anymore! very frustrated...Must go out for a run..

if anyone can help I appreciate it.

Al in Nebraska

* Al Rainey <raindude@Ihatespam.com>:
> Ok, so I have been up since early this morning actually focusing on 
> Filemaker, and the database I have been thinking about building since I 
> got my mac (a workout log)... Call me a procrastinator..
> 
Fascinating...but this is a database group not a psychiatric group.

> I'm beginning to see why it is considered so user friendly, as quite a 
> few things have clicked.
> 

-snipped-

> I want a script that will create a related cardiomain record, setting 
> the fkeyuniquedayId, and create related detail records in the portal, so 
> that when i add a new record, it sets the fkeycardiomainID to the 
> related record in cardiomain.
> 
> I can't thank about it anymore! very frustrated...Must go out for a run..

Not a running group either no matter how much you thank it is.

Your question is convoluted as hell but I think what you want to do is
create a new record in cardiomain and have it link up with your related
to your maindb, right?

In your cardio DB create a global field, in the MainDB have your script
set the cardiomain::gloalobal_field to the ID of the main db record.
Now create script in the cardio DB that creates a new record and sets
the cardioID from the global field.  As to the lasst part of your
question you gotta try posting it again a lot clearer.

loulou

> 
> The primary key in each field is a serial number. I need to make sure they
> are all tied together somehow.


That should read "primary key in each database".

* Al <raindude@cox.net>:
> 
>> 
>> The primary key in each field is a serial number. I need to make sure they
>> are all tied together somehow.

> That should read "primary key in each database".
> 
So you can still use the same method I explained earlier for all your
databases.

-ll