Form limited to insert and show only 1 record

Applications Forms
#1

Hi all,

I’ve to create a table and a form about where I want to record all LOGOS used on several application.
Becouse I need to have a unique global reference to a specific image on this table I have to limit the data entry to only 1 record.
Just to be more clear
logo_id
logo_100x50 --> Database image
logo_100x100 --> Database image
logo_200x50 --> Database image

Which could be the trick to limit to one record only the logos table ? I’ve to do the constraing on DB side or have I to do it in SC form ?
I imagine to hide toolbar button i.e.

Many thanks
Giovannino

#2

Insert a default empty record in the table with the key you need. Then delete the insert and delete button from the toolbar. If you open the application it will default show only the save button and show the current record.

#3

Hi Aducon,

It sounds nice, thanks.
Tomorrow I’ll try it !
Bye

#4

I’d confirm the trick works. The only thing you have to activate is “Update” and “First” record on footer otherwise nothing happens.
Strange the needing to insert something on footer, but after many tests I realized it.
Bye