oh my my

[timmy]

Alrighty. Here's the situation: I have two databases. There is a relationship between the two databases between a calculation field "BLUE" in one database and a calculation field in the second. That part works fine.

The problem: I have a portal in the second database. In this portal i have a field that is used in the calculation of "BLUE". Therefore, I cannot enter data and create a new record in the portal because the fact that this record is IN the portal is dependent on the field. Does that make sense?

Hmmm, i'm not sure how clear that is. Basically I want to be able to add records through a portal and somehow autoenter data into a field, so that it matches the requirements of the relationship.

Okay, I dont know how clear that is. If it doesn't make any sense, let me know and i'll try again. Thanks,

timmy.

[LiveOak]

You don't have to use the feature that allow the creation of records using a blank line in the portal. You can create a related record by other means. One way is to enter data into global fields in you main file then click a button which runs an external script in the related file and creates the related record and sets up any field necessary for the record to display in your main file.

You can access globals from another file by creating a relationship based upon a calculated "Constant" field in both files as follows:

Constant (calculation, indexed, number) = 1

and then relate the files matching Constant <---> Constant. This allows you to access globals from another file.

-bd