How to display all records in Portal

[talenone]

Hello Everyone,

Scenario: I have created 2 tables namely Agreement and Agreement Details, where AgreementId is primary key in Agreements table and refered as a foreign key in Agreement Details. I am capturing details from screen and passing to these 2 tables.

Requirement: I want to display all records captured in the above scenario on a PORTAL on a different screen.

Problem: The PORTAL is displaying data on record by record basis BUT I want all records to be displayed like a list.

Please assist, I am stuck.

Thanks,

-DS.

[comment]

A portal displays (only) related records. The best way to display all records "like a list" is a list view of the Agreement Details. table.

If it must be in a portal, then you need another relationship that would make all records related (i.e. using the x relational operator).

[comment]

Sorry, I am afraid I don't follow what you mean.

[talenone]

Hello Everyone,

Scenario: I have create a table namely Agreements, where i have 3 columns namely Id, Tag and Value.

Requirement: While entering data from screen I want to save data like this:

Id Tag Value

1 A 123

1 B 456

2 A 101

2 B 204 and so on.

How can I store/save data like this in a table, appreciate if someone could let me know exactly what needs to be done.

Please assist, I am stuck.

Thanks,

-DS.

[RalphL]

You will hear from Lee for double posting. This has nothing to do with Script Triggers or SQL. You use SQL term "Column" FMP uses "Field" & "Row" = "Record". When you enter data, it is automatically stored.

[Lee Smith]

You will hear from Lee for double posting. ...

Hi Ralph

LOL

I have deleted the other post

Lee

[comment]

To make things even worse, I suspect this is a repeat of:

http://fmforums.com/forum/topic/81995-how-to-display-all-records-in-portal/

[Lee Smith]

I wrote the OP when I deleted the other post earlier, about multiple posting their question. I'll merge the other topic with this one since they seem similar.

Lee

[talenone]

Thanks Lee.

Now post things have sorted out so now lets concentrate on the solution.

So Mr. Consultant do you have the answer.

Thanks,

-DS.

[LaRetta]

I have off-set all of the negative ratings on this thread. Rating Post #3, #5, and #7 were set as negative and that is not the purpose of ratings - simply to flag something as negative just because the person does not give a perfect answer, particularly when the question is unclear.

I have corrected them all by setting them with plus except Ralph where I accidently clicked negative as well (giving you two negative ratings, Ralph, my apology - I have asked that it be corrected).

DS, did you try what was suggested in post #2? Do you have more information for us so we can figure out what you want?

[Lee Smith]

I have corrected them all by setting them with plus except Ralph where I accidentally clicked negative as well (giving you two negative ratings, Ralph, my apology - I have asked that it be corrected).

I fixed it for Ralph. Thanks for your help LaRetta.

Personally, I don't like the down buttons, I would prefer that the dissatisfaction be handled through the report post functions.

I do like the concept of a thumbs up though.

Lee

[LaRetta]

Thank you, Lee. :laugh2: