Page 1 of 1
subform and lookup object
Posted: Fri Mar 23, 2018 12:14 pm
by 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.
Re: subform and lookup object
Posted: Mon Mar 26, 2018 1:12 am
by 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
Re: subform and lookup object
Posted: Thu Mar 29, 2018 8:52 am
by 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.
Re: subform and lookup object
Posted: Fri Mar 30, 2018 1:33 am
by admin
mskat,
I'm not sure what to say.
I works for me OK.
2lookups.PNG
Steven