Jump to content

oh my my


This topic is 7638 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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,


Link to comment
Share on other sites

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.


Link to comment
Share on other sites

This topic is 7638 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.