I am building a data collection application and I have two forms, populate_data and abstraction. I have imported data to the populate_data form and have a unique column of data called form_number. On my abstraction form, I would like to create a lookup field on the form_number column of data in the populate_data form so that certain data fields in the same row as the form_number I select in the lookup field from the populate_data file will populate to respective fields on my abstraction form.
I would like to do this without using a subform.
Any help will be appreciated.