LookTable

SuperSage77
SuperSage77 Member Posts: 101
How create a looktable from a Form (wicha as been created on this Table) for to recover the selected data and update the form with this data. Like F5 in the Form ITEM ?

Thanks for a response

Comments

  • Mbad
    Mbad Member Posts: 344
    Look at the item button on the item form, and look at the item table properties. that should be all you need to know.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    How create a looktable from a Form (wicha as been created on this Table) for to recover the selected data and update the form with this data. Like F5 in the Form ITEM ?

    Thanks for a response

    Not sure exactly what you are asking, but I see two possibilities.

    1/ you are trying to DUPLICATE the F5 fucntionality on the Item card which opens the Item list. If so then go to the Properties of the Button or Menu Item, and look at the property "Action" and set this to Lookup Table.

    Tehn you need to go to the source table of the Lookup form that you have created, and find the property "LookupFormID" in this property on the TABLE type the NUMBER of the Lookup form you want to "F5" to from the card.

    I also recommend that you set the ShortCutKey to "F5" to be the same as the rest of the system.

    If in fact you are trying to create a function that will find a record from a list and COPY that data into this record, then you need to post more information.
    David Singleton