Hi everybody,

I would like to know how to link data I enter on a portal in a record with another record with the same fields and portal. For example:

The first and second records have same:

- 2 portals format with relationships water quality, water quality_1

- 2 Fields (parameter) format with popup menu using same value list (including some parameters like BOD, COD...)

- 2 fields (value) using relationship water quality, water quality_1

- 2 fields (unit) using relationship water quality, water quality_1

These fields will distribute into 2 portals:

Influent portal Effluent portal

parameter value unit parameter value1 unit1

BOD BOD

COD COD

I want to link Influent portal with another record because I don't have to enter other data for it. I only change Effluent data like BOD, COD because they have different parameters for every experiment. I have to make other records for every experiment with same Influent but different Effluent so I want to keep Influent data and only enter data for Effluent.

Could you help me solve this problem?

Hope to get your help soon

Snow

Hi Snow,

I bet you won't like my answer.

Having parameter_1, parameter_2 is not a good structure in my opinion.

It leads to the same limits as repeating fields....because it end as a repeating value.

I may be wrong though, but I had very bad experience with these kinds of setings in my first db, as soon as a non planned parameter_3 got introduced.

When do you meet your advisor

just set your jey for Influent to "inherit" the value from previous record. This will, however, not create separate records in related Influent file. For this, you will have to script.

Thanks for your help, Ugo and Jager. I like all the answers because they help me solve the problem. I use field parameter as a popup menu including BOD, COD,....to choose the item for each parameter I have to enter the value. I don't need to write again their name on another portal for Eflluent. I can choose it then I only enter value. Unit is also linked with parameter by a list already. So I have to make a script like Jager said but I don't know how to make a script fot this case. Can you help me? I will meet my advisor tomorrow afternoon.

Hope to hear from you soon

Snow

Hi Snow,

There was a post not long ago here [color:"red"] hope the poster is reading that had [color:"red"] a two file demo of MultiKeys I have just look for about 30 minutes and can not find the files.

[color:"red"] Does anyone remember the files, can someone point Snow at them?

TIA

Lee

Lee, there are lots of example of Multikeys here. What was the file showing exactly ?

Snow, rereading your first post, I'm afraid I misunderstood the category and category_1, as it seems they are only named differently for relationship issue. Therefore, no problem.

Now, from what you're saying, I don't see the need for two portals.

I would rather categorize a field with Effluent or Influent.

Then 2 or more lines within a single portal related to a Line Item, as you explicit mentionned...

because they have different parameters for every experiment. I have to make other records for every experiment with same Influent but different Effluent

...that there is a many to many relationship.

Hi Ugo,

It was for this two portal concept that this came up off list.

The files I was referring to were two concepts, one on dates and other was either text or numbers, but the poster (I though it was Bob or Ray) had put them together in the same folder. I also thought it was in the Sample files, but I sure couldn't find it.

Lee

Bob released a Date Range Sampler and I'm sure it was called Multikey.fp5....

Are you saying that you would keep the 2 portals technique. Seems weird for me....but you may know better Snow's case.

Not necessarily, she brought this up off list and I told her that this type of portal is not my strong suit, and suggested that she download Bob's Sampler to see if it did what she wanted.

Snow need's it to be simple to follow and implement. (That's the way I like it too)

Lee

Thanks for your help, Lee and Ugo. As for my problem, I need to make a record with some portals. These portals will depends on the field date (text). For exampple,

A Water treatment plant has a database for their treatment. They want to update their database by new data every month or every running the treatment plant.

Here is the description

In Date field (text) I type: Run I, June 5, 2003

goes with 3 fields:

Influent (location field)

Effluent (location_1)

Effluent_1 (location_2)

I made 3 portals with different relationship to show separate record for each portal. In each portal, I put 3 related fields from their relationship

portal_1

parameter

value (text)

unit

portal_2

parameter_1

value_1

unit_1 (mg/l)

portal_3

pararmeter_2

value_2

unit_2

What I need is to keep value of parameter for everytime I enter new data for every Effluent because it often has a same Influent but different Eflluent value. I also want to make a relationship between date field and new record for Eflluent so that I can enter new data for Effluent every month. How can I change or open a new empty effluent portal (portal_2 or portal_3) with empty place to enter value for parameter field and still keep the portal Influent by side with old value?

I am sorry if I cannot write this clearly.

Hope to get your help soon

Snow