Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Unable to create a new record through a portal

dodds
in Portals

Featured Replies

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

Is there a question?

was thinking the same thing. Perhaps a double post!

"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 by LaRetta

Create an account or sign in to comment

https://fmforums.com/topic/83073-unable-to-create-a-new-record-through-a-portal/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.