Forum Creation

558
3
05-03-2013 12:04 PM
MatthewDondanville2
New Contributor III
Does anyone have a solution for nested forms in ArcGIS.

Problem:
There will be 10 field guys with laptops with a stripped down ArcGIS on it. They will click on a point (Pole) and a access database form will appear with nested (relationships?) form for the field guys to fill out.

The updating features, all the poles are GPS located in the database and have a xy and pole number. This inventory system will have the field crew out and they will fill in the data asked on the nested form. This data will be "new data" added to access columns and selected from drop downs on the forms. Sometimes, the forms will already have data such as "last maintenance" and the field will be updated with the current date. The current data is in a SQL geodatabase.

We are looking for a way to create forms as well as "nested" capabilities, Relationships?

Database nested classes are attached below
0 Kudos
3 Replies
RobertBorchert
Frequent Contributor III
Consider ArcPad.

Your field guys can check out data and make updated in the field.  Bring their device back in and update the data in your GDB.

You can create tables with domains such that they pretty much only have choices from drop down menu's for choice then you  can have a comment section.


Does that sound like what you are looking for


Does anyone have a solution for nested forms in ArcGIS.

Problem:
There will be 10 field guys with laptops with a stripped down ArcGIS on it. They will click on a point (Pole) and a access database form will appear with nested (relationships?) form for the field guys to fill out.

The updating features, all the poles are GPS located in the database and have a xy and pole number. This inventory system will have the field crew out and they will fill in the data asked on the nested form. This data will be "new data" added to access columns and selected from drop downs on the forms. Sometimes, the forms will already have data such as "last maintenance" and the field will be updated with the current date. The current data is in a SQL geodatabase.

We are looking for a way to create forms as well as "nested" capabilities, Relationships?

Database nested classes are attached below
0 Kudos
MatthewDondanville2
New Contributor III
Thanks for your response.

I know how to make drop downs, but need nested drop downs. For example, we want logical drop downs, when selecting a utility pole, if you select a wood pole it will give you the wood pole manufacturers and not the metal pole manufacturers and so on.

Also, looking for a way to have a QC/QA on check in, that will not add the updated data back to the geodatabase without being approved. If you could point me in the right direction.
Thank
Matt
0 Kudos
MarcoBoeringa
MVP Regular Contributor
Problem:
There will be 10 field guys with laptops with a stripped down ArcGIS on it. They will click on a point (Pole) and a access database form will appear with nested (relationships?) form for the field guys to fill out.

The updating features, all the poles are GPS located in the database and have a xy and pole number. This inventory system will have the field crew out and they will fill in the data asked on the nested form. This data will be "new data" added to access columns and selected from drop downs on the forms. Sometimes, the forms will already have data such as "last maintenance" and the field will be updated with the current date. The current data is in a SQL geodatabase.


Do I understand it right you are using a Microsoft Access database as a fore front to a SQL Server enterprise database, and call these Access forms from a custom ArcGIS Engine application? To be honest, if so, this might be a better question to pose on a Microsoft Access/SQL Server forum. I don't think to many people here have dealt with this specific setup and will be able to answer this Access specific question.

Thanks for your response.

I know how to make drop downs, but need nested drop downs. For example, we want logical drop downs, when selecting a utility pole, if you select a wood pole it will give you the wood pole manufacturers and not the metal pole manufacturers and so on.


This specific requirement sounds like you want Geodatabase subtypes with their own domains. Start looking into that:

A quick tour of subtypes
0 Kudos