Form: Display a newly added field from a View

(0) Share

Report

Posted on by lmes

390

Hi all,

Please help.
I would like to get some information that can spark me to create an idea to solve my problem.

I have a form, it has a grid to display data from its view. This view is from a query.
In this view, I have a column called Invoice.
Now I have a new table storing a invoice name and its assigned number. I would like to also display this assigned number.

Then I add this table in the existing query.
I open my view after I add the table, the view is viewable.
Then I go to my form and add a new field from this view to display the assign number.
When I save the form and compile, error message popped up:
Unable to save Control ____(The field I newly add)____ .

Please advise which part may be wrong and resulting this problem. Many thanks in advance.

Kind Regards,
4274.photo1.png

*This post is locked for comments

All responses (5)

Answers (1)

lmes 390 on at

Like (0)

Report

RE: Form: Display a newly added field from a View

Yes the grid's Data Source is a view.

And this view is composed of 1 parent table and 2 child tables.

One child tables is added newly.

The expected new column is from this table.

I can open the view after modified. Yet I cannot add a field to view it in the form.

Many thanks for reply again.
Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report

RE: Form: Display a newly added field from a View

also check if the grid is bound with table group instead of individual fields.

that case you have to add field to table group. or change the grid property to remove the group.
lmes 390 on at

Like (0)

Report

RE: Form: Display a newly added field from a View

Hi Amir,

I have tried to restore the form and reassign the data source,

when I restore the data source, the field I added is removed.

Yet thanks for the help.
lmes 390 on at

Like (0)

Report

RE: Form: Display a newly added field from a View

Hi Amir

Thanks for the fast reply, let me take a took on it.
Verified answer

Amir Nazim 5,994 on at

Like (0)

Report

RE: Form: Display a newly added field from a View

are you able to view the correct data in view ?

then it should not be more than a refresh issue, try restore and refresh that form and data source on that form.