Select more than one record
Posted: Thu May 17, 2018 6:52 am
A Lookup Object is used to select one record from another table. Now I need to be able to select several records at once.
An example would be when searching for the word "fruit" and then one could select a certain selection of fruits or to search for a company's name and then pick the individual employees of that company. The selected records would then be transferred to a subform grid of the calling form. Up to 20 records can be selected form the lookup form so it would be very tedious if each record had to be selected individually.
A) Is this feasable with a lookup object ?
B) If not, is there another possiblity?
An example would be when searching for the word "fruit" and then one could select a certain selection of fruits or to search for a company's name and then pick the individual employees of that company. The selected records would then be transferred to a subform grid of the calling form. Up to 20 records can be selected form the lookup form so it would be very tedious if each record had to be selected individually.
A) Is this feasable with a lookup object ?
B) If not, is there another possiblity?