Dear All, I have a problem to activate lookup of a new field in a certain card. BAsically, I create a new table with fields consists of code & description. I create its form. Their ID numbers are 49999 & 49991. I create a new field in a card with type code and in tablerelation is the new table ID 49999. I hope when I click lookup button, I can open the form ID 49991, however it does not work good, meanwhile if I use another table in the new field’s tablerelation in properties, it works good. Please let me know how to connect them all. Tks for your reply beforehand Rgds, Mark
You need to define the lookupformid in the table. This is a property
Tks for your prompt reply, but do you mean in the property of new field of the new table I made or the new field I made in the card ? Moreover, I can’t also find lookupformid, I am still searching it… rgds,
It is a property of your new table. To change the tableproperties put your cursor on a new line below the last field in the table and then press shift+F4
quote:
Tks for your prompt reply, but do you mean in the property of new field of the new table I made or the new field I made in the card ? Moreover, I can’t also find lookupformid, I am still searching it… rgds,
Originally posted by mark_christs - 2006 Apr 05 : 07:51:01
First you need to create a tabular form based on your new table or, if you already have one, make sure that its LookupMode property is set to yes. Then you open the new table in design, click on a blank line (the one next to the last field in the table) and open the properties sheet. There you will find the properties LookupFormID and DrilldownFormID. Set both to the abovesaid form ID. Anna
Dear all, tks a lot for your reply and answers, I think Miss Ana more clear but nevertheles all is good, I have created and used what I ask but I need help again, where I can’t use the new form per each item, for example, I click item button of item A in the item card, then select item variants, there will come item variants form for item A, if I do that again for item B then the item variants form for item B appears. But I don’t knoe why my table showing empty no. of the item ? Tks a lot for your attention. rgds, Mark
Dear all, I am waiting your answer so much. Could you answer my question ? rgds, Mark
quote:
Dear all, I am waiting your answer so much. Could you answer my question ? rgds, Mark
Originally posted by mark_christs - 2006 Apr 11 : 02:43:58
I gladly would if I understood the question. Would you please try to rephrase it? Thank you Anna
You have (most probably) forgotten to apply a FormView to your MenuItem (or Command Button) Please compare property by property of the “Item Variants” button with the properties of your command button (MenuItem).
Hello, If you added the new menu button. 2 things are required to run a subform that is linked to the main form. Keeping with your example of an Item card. See submenu Variant: Caption=Variant Action=RunObject RunObject=Form Item Availability by Variant Next see the property of the submenu Variant, Yes property. PushAction=RunObject RunObject=Form Item Availability by Variant RunFormLink=No.=Field(No.),GlobalDimen… RunFormLinkType=OnUpdate This should link up with the necessary fields, only the first is really the link (RunFormLink). The other are just flowfilters that can be passed from the item card.
Dear all, tks a lot for your prompt answer and reply and also kindness. I have tried your advices and it works good but it is especially what Gfuentes suggested. more power to your all. rgds, Mark