This is a Dumba$$ question - I want to allow my users to edit allthe VLs in one layout

How folks, I am newbie to FM, Have used Clarion, access, vb etc. I want to
have a layout that has each of my value list files displayed as a list for
editing creating, modifying and "deleting" entries. Now when I delete, I
want it to only hide it in the list for new records - old records get to
keep their current value, if a value exists in a related record.

I need some help.

Many thanks Stephen

Re: This is a Dumba$$ question - I want to allow my users to edit all the VLs in one layout

I'd say it's easy (if I understand you enough) : you just create a new
table named 'Param' with only one record. Then in it you create as many new
(regular) fields (non globals) as you need value lists. Say 'Title' with Mr,
Mrs, Ms, Dr each separated by a 'paragraph return'. Then from any other
table you may call 'Title' as a value list. If you choose 'Dr', that 'Dr'
will stay in the other table record if you remove it from the 'Param'
'Title' field table.
Please correct me if I am either wrong or uncomplete.
Remi-Noel


"Stephen Holland" a écrit dans le message
de news:C3BACF1D.38F3%stephen.holland@optusnet.com.au...
> How folks, I am newbie to FM, Have used Clarion, access, vb etc. I want to
> have a layout that has each of my value list files displayed as a list for
> editing creating, modifying and "deleting" entries. Now when I delete, I
> want it to only hide it in the list for new records - old records get to
> keep their current value, if a value exists in a related record.
>
> I need some help.
>
> Many thanks Stephen
>

Re: This is a Dumba$$ question - I want to allow my users to edit all the VLs in one layout

Stephen

A value list is just like the keys on your keyboard. Once you have typed the
character it stays there, even if after the key is disabled. So when you hit
a value it sets the value in a field. When you then delete the value it
still stays in the field. You can check this by just using a normal field
next to your list, checkbox or whatever you have used.

Keep well, Ursus

btw, please state version and platform next time.

"Stephen Holland" schreef in bericht
news:C3BACF1D.38F3%stephen.holland@optusnet.com.au...
> How folks, I am newbie to FM, Have used Clarion, access, vb etc. I want to
> have a layout that has each of my value list files displayed as a list for
> editing creating, modifying and "deleting" entries. Now when I delete, I
> want it to only hide it in the list for new records - old records get to
> keep their current value, if a value exists in a related record.
>
> I need some help.
>
> Many thanks Stephen
>

Re: This is a Dumba$$ question - I want to allow my users to edit all the VLs in one layout

In article , Stephen
Holland wrote:

> How folks, I am newbie to FM, Have used Clarion, access, vb etc. I want to
> have a layout that has each of my value list files displayed as a list for
> editing creating, modifying and "deleting" entries.

You can let users edit the Value Lists directly via either the menu
option or a script / button with the Open Define Value Lists command,
but this can be dangerous with "dumba$$" users.

Another possibility is turning on the "Edit" option for the field's
formatting, but this only works with Pop-up Menus and Lists and isn't
particularly user-friendly (although better than the Define Value Lists
window).

You could instead simply use turn on the "Other" option in the field's
formatting, but this doesn't work for Pop-up Lists.

The best answer is usually to store your 'value lists' in a separate
table (either as separate records for each value or as a Text field
with Return characters between each value). Using separate records
allows you more flexibility since you can easily use the Validate
options to make sure users enter values correctly (eg. must be unique).
You can then define you Value List to retrieve its values from these
field(s).



> Now when I delete, I want it to only hide it in the list for new records
> - old records get to keep their current value, if a value exists in a
> related record.

Any data entered by the user into a field that uses a Value List is
stored as normal. Even if you later change the Value List items the old
data remains ... but there can be problems later Finding records using
the old data. To get around this you may need to use a Find layout
where you simply type in the wanted data or you could use two Value
Lists - a short one for data entry and a long one that still contains
ALL possible values for Finds.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: This is a Dumb$$ question - I want to allow my users to editall the VLs in one layout

Folks,

Thank you all for your responses. I will try them out and go from there.

My next trick to to show the 4 Value lists on the same layout and allow the
client to add and delet in a portal view (that is 4 portal views on the same
layout).

Many thanks

Stephen


On 22/1/08 7:08 AM, in article
220120080908344276%helpful_harry@nom.de.plume.com, "Helpful Harry"
wrote:

> In article , Stephen
> Holland wrote:
>
>> How folks, I am newbie to FM, Have used Clarion, access, vb etc. I want to
>> have a layout that has each of my value list files displayed as a list for
>> editing creating, modifying and "deleting" entries.
>
> You can let users edit the Value Lists directly via either the menu
> option or a script / button with the Open Define Value Lists command,
> but this can be dangerous with "dumba$$" users.
>
> Another possibility is turning on the "Edit" option for the field's
> formatting, but this only works with Pop-up Menus and Lists and isn't
> particularly user-friendly (although better than the Define Value Lists
> window).
>
> You could instead simply use turn on the "Other" option in the field's
> formatting, but this doesn't work for Pop-up Lists.
>
> The best answer is usually to store your 'value lists' in a separate
> table (either as separate records for each value or as a Text field
> with Return characters between each value). Using separate records
> allows you more flexibility since you can easily use the Validate
> options to make sure users enter values correctly (eg. must be unique).
> You can then define you Value List to retrieve its values from these
> field(s).
>
>
>
>> Now when I delete, I want it to only hide it in the list for new records
>> - old records get to keep their current value, if a value exists in a
>> related record.
>
> Any data entered by the user into a field that uses a Value List is
> stored as normal. Even if you later change the Value List items the old
> data remains ... but there can be problems later Finding records using
> the old data. To get around this you may need to use a Find layout
> where you simply type in the wanted data or you could use two Value
> Lists - a short one for data entry and a long one that still contains
> ALL possible values for Finds.
>
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: This is a Dumb$$ question - I want to allow my users to edit all the VLs in one layout

In article , Stephen
Holland wrote:

> Folks,
>
> Thank you all for your responses. I will try them out and go from there.
>
> My next trick to to show the 4 Value lists on the same layout and allow the
> client to add and delet in a portal view (that is 4 portal views on the same
> layout).

There is no problem having multiple Portals on the same Layout, except
in the case of Scripts.

Any scripts used must make sure they are in the correct Portal before
using commands like "Go To Portal Row [First]". The best way to do this
is to go to one of the related fields before using the command.
eg.
Go To Field [MyPortal6::MyField]
Go To Portal Row [First]

This will go to the first row in the Portal for the Relationship
"MyPortal6".

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: This is a Dumb$$ question - I want to allow my users to editall the VLs in one layout

Thanks Harry, I will give it a try


On 23/1/08 7:00 AM, in article
230120080900043544%helpful_harry@nom.de.plume.com, "Helpful Harry"
wrote:

> In article , Stephen
> Holland wrote:
>
>> Folks,
>>
>> Thank you all for your responses. I will try them out and go from there.
>>
>> My next trick to to show the 4 Value lists on the same layout and allow the
>> client to add and delet in a portal view (that is 4 portal views on the same
>> layout).
>
> There is no problem having multiple Portals on the same Layout, except
> in the case of Scripts.
>
> Any scripts used must make sure they are in the correct Portal before
> using commands like "Go To Portal Row [First]". The best way to do this
> is to go to one of the related fields before using the command.
> eg.
> Go To Field [MyPortal6::MyField]
> Go To Portal Row [First]
>
> This will go to the first row in the Portal for the Relationship
> "MyPortal6".
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships ;o)