Unable to create a new record through a portal

[dodds]

As an example, I have created a very simple FMP11 file with two entities, 'clients" and "commandes". "commandes" has two fields, _kp and "numéro de commande" which is a number auto enter serial number.

There is an OT "clients_COMMANDES" linked to the entity "clients".

Link to "clients_COMMANDES" allows record creation from "clients" entity.

There is a view "clients" associated with the entity "clients" ans a portal associated to the OT "clients_COMMANDES" on this view.

I am unable to create new "commandes" records through the portal.

On the contrary, if the field "numéro de commande" is simply a number, not an auto enter serial number, no problem for the creation of new records

[Fitch]

Is there a question?

[imoree]

Is there a question?

was thinking the same thing. Perhaps a double post!

[LaRetta]

"commandes" has two fields, _kp and "numéro de commande" which is a number auto enter serial number.

_kp indicates it is the primary key for the table. It is the primary key which holds the auto-enter serial. This might be what you have wrong. The 'parent key' (the 'one' side in a 'one-to-many') must be placed in the child table (the 'many' side) then match the keys using '=' and make sure both keys are of same data type.

There is an OT "clients_COMMANDES" linked to the entity "clients".

Link to "clients_COMMANDES" allows record creation from "clients" entity.

There is a view "clients" associated with the entity "clients" ans a portal associated to the OT "clients_COMMANDES" on this view.

Very nice and clear explanation of your existing situation. Thank you for making it easy for me to interpret.

I am unable to create new "commandes" records through the portal.

On the contrary, if the field "numéro de commande" is simply a number, not an auto enter serial number, no problem for the creation of new records

See how the attached works for you. You can type into the Commandes portal on Clients layout. Then check the graph and how it is constructed and that the key fields are the ClientsID in both tables. Notice that the 'allow creation' is checked on the Commandes side? Note what you said in blue above - did you check it on the Clients side by accident?

Let us know how it goes. :^)

UPDATE: Added blue

Commandes.zip

Edited March 28, 2012 by LaRetta