-
Hey there.
You have run into one of the limitations of the Database type form. You can only query and submit one table structure, you are bound to certain table relationships, and an insert adds all tables or the whole structure.
You either need top create new seperate forms for the seperate tables or use web services.
Typically we use ...
-
This is simple to do but you need all of the information.
You would need to identify the form user.
Then whether they are a manager.
And then add conditional formatting to the form to hise the section or have a seperate view, which ever is appropriate.
You may be interested in the Database Accelerator to keep a list of managers or in the ...
-
You would need a second view which is read-only or what ever you wanted.
Then you need a field in your form to track the state of the form, submitted or not. There may also be a field which would be blank on a new form and has a value after submit, this would work for detecting whether the form was new or submitted. Once you have your ...
-
Hi
After I submit the form to sharepoint list, I'd like to open the form in new view. Is it possible? Readonly or just text. Is there a website show me how to to it?
Thanks
-
Thanks, I'll do that when I have it.
-
I've found importNodeNode function. I'll try to use it.
-
Hi,
I have an ordering system where a staff member makes an order and submits it.
Once submitted I have a field on page 2 called 'stage' and this displays the number 2 once submitted the staff member submits their order for approval.
In Sharepoint I have created a view which shows each stage of your order and how far it ...
-
Hi,
I have an ordering system where a staff member makes an order and submits it.
Once submitted I have a field on page 2 called 'stage' and this displays the number 2 once submitted the staff member submits their order for approval.
In Sharepoint I have created a view which shows each stage of your order and how far it has ...
-
Hello,
I have my form connected to a database. The database has three tables in it - General, FJobs, and Jobs. The three tables are all linked with the ID field. When I connect my form to the database, I added all three tables. I notice that General - which I added first - has the "repeating" box checked on ...
-
Hi,
I have developed a form using MS Infopath 2003. Before I have already developed the same form using MS Access 2003 and the data can be stored in Access table. After I have developed the new form using Infopath, I want the data to be saved in MS Access table that I have created before. How to link these two files together because I want to ...