One Field on layout, must display data from other fields

[Adri Oosterwijk]

Hi,

I think this is maybe a simple issue, but I'm not able to figure it out at this moment.

This is what I want to accomplish:

In my settings table there is is field called SelectBy. The values are Row and Item.

This is a global field. This value is set for the entire solution.

The user can make reservations for the customers. User goes to the reservations layout and has to input in a field for wich Row or Item the reservation is made. On this field the data will be entered using a valuelist.

Case is this: is it possible that the user can input in only one field the data required using the right valuelist. All based on the settings (SelectBy). So when in de setting table the value Row is selected the input will be: Row-1-1-1, Row-1-1-2 etc and in case the setting is Item the values will be Item-1-1-1, Item 1-1-2 etc.

When this is possible it will save me a lot of work creating all different layouts.

I hope to hear soon and thanks in advance.

Kind Regards,

adri

[bcooney]

Sorry, don't understand your interface. Can you post a file?

[Adri Oosterwijk]

Hi bcooney,

Here is the file. It's a test file but i hope it will make things clear.

I hope it will be clear to you because it is in Dutch.

On the lay-out "Reserveringen" the upper left field is Rij(Row) with a value, entered using a valuelist.

I want to accomplish that by changing a setting form Rij(Row) to Item on the "Programma, licentie en stamgegevens" layout it will be possible that the mentioned field is displaying data from another field. So no second layout wit a different field (and valuelist) but te same layout with with the values (and valuelist) of anoter field.

I hope this will make sense (it's a bit difficult for me to explain it in English).

Kind regards and thanks for the quick reply.

Adri

[bcooney]

Oh, where's Soren when you need him!

I'm not able to see what you're doing (although your graphic design is very nice).

Some random facts:

1. Globals are specific to a user's session. Therefore, in a multiuser application, global fields must explicitly be set (usually in a File Open script).

2. You cannot dynamically change the value list assigned to a field. Perhaps, that's your goal?

hth,

Barbara

[Adri Oosterwijk]

Hi Barbara,

Thank you for your reply. I'm glad you like the design so far.

Sorry that my explanation wasn't clear. I will try to update this.

I have altered the startup script a little so after startup you are getting the layout "Reserveringen"

The first field (upper-left) is called Rij. The values are added using a valuelist.

This is ok in one case. I'm planning to make a settingsfield (in an other table) where the user can choose if he wants to make a reservation (reservering in dutch) by Rij (Row) or by Item.

If the user sets it to Item the field Rij has to change in field Item. Both situations needs there own valuelist to add data into the field. I can make this work wit two layouts but I want to avoid that because that means a lot of extra layouts further on in the solution.

I.m aware of the problems with global fields, because it will be a multi user solution.

And... yes, I want to call a valuelist from a script (based on the value "Rij" or "Item"). When this is not possible is there another way? (Perhaps two fields on top of eachother, accessible yes/no based on the value "Rij" or "Item"?

I hope it is more clear now.

hth,

Adri

[Adri Oosterwijk]

Hi Barbara,

I found a solution to my problem. see attached file. At the bottom of the layout "Resereringen"

What I did was the following:

I placed a TabControl item on my layout with tw tabs. I gave the tabs an object name.

Te tab contraol has the same color as the background, no borders or effects and I set the Tab with to 0.

Now by changing the setting from Rij to Item and back a script is triggered en set to go to the specific panel (by object name).

As far as I can see is it working great.

Thanx for your help.

Adri

[bcooney]

A hidden tab panel is a great solution, because you can't change a value list conditionally.

What is the user selecting, though? Your value lists look as if you having the user select a text value, rather than an ID.

[Adri Oosterwijk]

Hi Barbara,

Inded the user is selecting a text value. Te valuelists are populated by a textfield and the values of that textfield is a sum of different other textfields.

Do you see any upcoming problems with this method?

Regards,

Adri

[bcooney]

Yes. Ideally, selections store IDs. You may display a corresponding text value, but the record is actually storing an ID. What do these text values represent?

[Adri Oosterwijk]

The solution will be used as a tool to manage cemeteries. Here in Holland the approach can be different. In one case people can make a reservation in a given row while on another cementerie the reservation can be make to a specific grave.

The values stored is in the first case a Rowname. This is the sum of the fileds "Sectie" (section), "Vak" (area), "Rij" (row). When editing data the "Rijnaam" (rowname) is stored with the record. (see layout "programma, licentie en stamgegevens in the file.

In the other case I'm using the field "Grafnummer" (gravenumber) in the valuelist. This field is the sam as 'Rijnaam" (rowname) with addition of the "Nummer" (number) field.

So when the setting "Rijnaam" (rowname) is made people are making reservations in a certain row and the graveyardmanager decides in what specific place the burial takes place.

With the setting "Grafnummer" (gravenumber) is made the reservation is made for a specific grave. The last option is easier to program because in the first case there must be an detection when de number of reservations exceed the total amount of graves in that row.

Ofcourse, every record has its own unique identifier wich are used to make relationships between tables.

So, it is a little bit complex but i hope that you are able to understand what I'm trying to do.

Have a nice day.

[bcooney]

I see, a booking system. You might wish to look at this demo from Ray Cologon: Booking System

[Adri Oosterwijk]

Thanks!

Thats helps.

I'm gonna study it more and i'm sure I can make several improvements.

Thanks for your help and till next time.

Adri