Re: Using an access database to populate forms

Clay Fox — Mon, 01 Dec 2008 05:55:17 GMT

Hi there.

Welcome to the forum.

You have a couple issues. One would be the size of your database in Access and the other is probably how you have it set up.

InfoPath has some constraints to how the table is setup.

You have to have a primary key. And any child tables must have a foreign key relationship.

In you scenario I do not think you want two tables. You would want one record which also had the approval columns or whatever else. Then your form will be able to query a single record. Allow updates and inserts. And then be able to submit the data back to Access.

With this you could have each person open up a single form template and query for their record. Or if you had their name or username you could get the username and then use that to query their records. You could email everyone the form or a link to it on a network share, which is even better.

I have also used simple VB scripts to generate forms from the command line, passing a variable to the form so that it gets the correct data, and then submitting to email.

They would view the data as they need, add the additional data, and then submit it via email or back to Access.

Hope that helps.

Using an access database to populate forms

Macm72188 — Mon, 24 Nov 2008 23:05:34 GMT

I am currently trying to create forms for over 1500 separate records all located in an access database. I need a form for each record that will be sent to supervisors for approval and then populate the approval field in the database. I am new to InfoPath and am running into major difficulties. I have created two tables in the database, one to submit and one to receive data, but when i try to fill out the form, all 1500 records are returned on one form. How do I get around this?

Thanks!

Newbie Questions

Re: Using an access database to populate forms

Using an access database to populate forms