Data from Related Table Not Appearing

[HeatherLandry]

I'm exporting data from a geodatabase out of ArcView usign the Get Data for ArcPad function.  I'm exporting the data into an axf format.  The parcel layer that i'm exporting is linked to a table that stores parcel ownership information via a relationship class.  It is a feature class to table, 1 to 1 relationship. 

When I load it to my mobile device, and click identify on one of the parcels, I can see the attribute information for parcel feature class, and only the field names for the related table, no data when there should be.  When I verify it in ArcMap, the related data is avaialble.

I'm using ArcPad 8, sp4.  I've reinstalled all the software and recreated the relationship classes.  Please advise.

[SarahAcMoody]

Hi Heather,

We're running into the same problem.  Did you ever find a fix for this?  Any help would be appreciated.

Thanks,

Sarah AcMoody
acmoodys@msu.edu

[RobertGoodwin]

I am having the EXACT same problem Heather and Sarah.  I have a many to one relationship and when my data is checked out to an AXF (disconnected editing), I cannot see the records in my relationship table.

Bob "in limbo"

[EricHajek1]

I haven't run into this issue personally (haven't had the "opporunity" to) but a potential workaround would be to implement a little code in the IDENTIFYFORM. Just like the EDITFORM of a layer, the identify form can be altered. The key difference is of course that it doesnt alter data.
Here's what I'd do:

Create a new identify form for the layer you want to query. Get rid of whatever is in there, and just add controls for the few key fields you need. So for the parcel example, show the parcel address and whatever other info you need. Add another control that isn't tied to a field, either an edit box (1:1) or a listbox (1:M,M:M), this example assumes an editbox.

To show the information you want in this control, use a SQL query:

'This is assuming that the code is executed from the onload event of the identifyform.

Dim query, ownername, thedatasource

'                                form                layer    datasource, which you need to execute SQL commands
thedatasource = ThisEvent.Object.Parent.Datasource

'note the single quotes enclosing the string we're querying against at the end
query = "SELECT [OWNERS NAME FIELD] FROM [TABLE RELATED TO PARCELS] WHERE [PRIMARY KEY FIELD] = '" & ThisEvent.Object.Fields("PrimaryKeyField").value & "'"

'returns a recordset object, see the help for other methods you can use. It will only contain the 1 field you queried for above
ownername = thedatasource.Execute(query)  

'Assign the value you got to the empty editbox you set up.
ThisEvent.Object.Pages("Page1").Controls("empty edit box for storing the owners name").value = ownername.Fields("OWNERS NAME FIELD").value

Hope this helps! I promise involving SQL isn't as scary as it looks above (really boils down to 5 lines), if you need some help modifying the syntax for your purposes feel free to post about it and I'll try and help!