subform and lookup object

[mskat]

I have a subform within a form. The subform has two lookup objects. When I go to the edit screen of the form all of the data for one of the lookup object is shown but for the second look up object only one of the row is shown. When I change the second lookup object to text or a select object, all of the data is shown.

[admin]

mskat,

Can you confirm that these ids are actual primary keys in your asset_class table.

lookup_ids.PNG

(My guess is that, I don't think they are).

Steven

[mskat]

They are values from the assetclass_id field which is the primary key in the table that was generated using the fastform. Acutally verified that before posting the issue. I am encountering this problem with other tables as well. Seems to occur when there are two lookup fields in the subform. Like I said, when I change it to text or select objects, the values appear.

[admin]

mskat,

I'm not sure what to say.

I works for me OK.

2lookups.PNG

Steven