Add a new record dynamically

[ssseeesss]

Is it possible to add a new record to a table without a layout?

One way I know to add a new record is using script steps like:

Go to Layout

New Record/Request

Set Field...

I have a many to many relationship with a connecting table. I don't want to create a layout for the connecting table, but still want to add a new record to the connecting table.

Thanks

[_henry_]

Hi,

Have you tried "Allow creation of records in this table via this relationship" option in the "Edit relationship?"

[ssseeesss]

Yes I did, but I need to find a way to create a new record in an unrelated table through scripting.

[_henry_]

Hi again,

I have a many to many relationship with a connecting table. I don't want to create a layout for the connecting table, but [color:blue]still want to add a new record to the connecting table.

Based on your first question, I thought you want to add new record to related table (connecting table), so I suggested about that relationship. As far as I know, you cannot add new records to unrelated table without its' layout. Maybe other FM guru can help you out in this issue if there's any method ;]

[Fitch]

If it's unrelated, then what is it connecting?

Do you have a layout for some Table Occurrence of this table, but just not this particular TO? If so, that's doable, any layout based on a TO of the table will do.

Set Variable( $id ; parent ID )

Go to Layout

New Record/Request

Set Field( parent ID ; $id )

[_henry_]

Here is one of FM guru's answer :

Bravo for Tom :thumbup:

[ssseeesss]

Let me make this clear. This is my simplified database structure:

Three tables:

Table_A

-------

A_ID

Table A_B

----------

A_ID

B_ID

Table_B

-------

B_ID

And relationship is (a common many to many relationship):

Table_A::A_ID--->Table_A_B::A_ID

Table_A_B:B_ID<----Table_B::_ID

In another separate layout, when the user specify A_ID and B_ID, a new record will be created in table A_B

Edited June 27, 2008 by Guest