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.

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).

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

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.

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.

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

Hi Ralph

LOL

I have deleted the other post

Lee

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/

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

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.

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?

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

Thank you, Lee. :laugh2: