Help with container

(0) Share

Report

Posted on by Community Member

Hi everyone,

I want to create a form where I have only table in that table I have two fields Employee id and Name and a container.

In that container I want to store the salary of employee.

For example :on form when I select a grid and click on the menu item it opens another form and there are. 3string edit available in which I will get the value from container.

There is no table to store salary.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Ok, do you have a question for us? Did you face some problems? And why do you want to use a container with 3 string fields for storing salary information? That doesn't sound like a very good design.

Also why would you want to store employee id and name in the same field?

How did you come up with this design?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sorry...there are 3 fields name ,id and a container.

I am trying to understand the practical use of container.

I have read Microsoft blogs and other blogs and I am not getting it.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,803 Most Valuable Professional on at

Like (0)

Report

All right, that explains why you're trying to use it in a completely wrong way. If you want store salary, use a numeric field, which allows you to easily use the field in forms filter and order by salary, summarize salary in queries and so on. Using a container, while technically possible, would make all these things impossible, therefore it would be a very wrong thing to do.

Container fields are used for very specific things - binary data, such as images, and serialized objects (such as objects saved to database to be processed later in batch, or packed queries).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for the response Martin. I did it the way you said.

I have one more question.

Suppose I have a grid on a form and a menu item which opens another form.

I am passing current record(selected on grid) argument to the new form and there are two string edit fields on that form which stores values related to that field(whose argument was received)

The value in these two string edit can be changed and every time the form is closed and reopened the value in the string edit will show the latest value which was inputed by user.

Also,there is no datasource in that new form.hence I am using container to show that value.

Please just give me an idea how this can be achieved.

Was this reply helpful? Yes No
Martin Dráb 237,803 Most Valuable Professional on at

Like (0)

Report

If I understand it correctly, you have a form for maintaining some data related. Users can modify the data, the data gets stored somewhere and it's loaded from the storage when the form is opened again.

Then it sounds like a normal form with a table. You should design a table related to the main table and create a form with the new table as a datasource. It doesn't seem to have anything to do with containers.

Was this reply helpful? Yes No