Method:Classic General Q&A

Re: Best practice for adding records to simple dropdown tables?

smohyee — Thu, 24 May 2012 17:54:36 GMT

Both good ideas that I have now adopted. Thanks guys!

Re: Best practice for adding records to simple dropdown tables?

jnoneiliv1 — Thu, 24 May 2012 13:49:52 GMT

Sam,

I do this also. The automatically created screen is perfect for those simple drop down tables. I have about a dozen of them and I just put them on a tab that users wouldn't see so when I want to add drop down values I just go to the auto screen and make entries.

Cheers,

James

Re: Best practice for adding records to simple dropdown tables?

Anonymous — Tue, 22 May 2012 14:21:08 GMT

smohyee:
is there a more convenient way to add a record to an existing table without having to design a screen/action set for it, short of deleting and recreating the table?

The best way I've found is to create a table first then create a screen with the table - this way you get an entry screen automatically made. If you create a dropdown inside a table you don't get the option to create a screen for the newly created table.

Best practice for adding records to simple dropdown tables?

smohyee — Mon, 21 May 2012 18:57:28 GMT

When creating a table related to a dropdown field, I'm given the option of initialising the table by adding any records I can think of. Once the table is created, I can no longer add records this way.

My solution has been to design a related screen for the sole purpose of adding records - an "Add/Edit Shipping Method" popup screen, for example. But this is overkill for those simple dropdown tables where I just forgot to add one record to my table when initialising it, and it is unlikely I will need to add another.

So I just thought I'd check: is there a more convenient way to add a record to an existing table without having to design a screen/action set for it, short of deleting and recreating the table?