I have one table, let's call it Master, that contains four fields - test, section, question#, notes.
The Master table compiles information from many users with notes about specific questions from certain tests. So, for example, there might be ten different people that are entering information into Master.
Each user also has a personal table, called MyTable, in which they can import information from the Master table for their own use.
To clarify, some user may have entered a record in Master that contains: Test 3, Section 4, Question 5, Note: Testing if/then logic
Another user might want to import this into their MyTable.
Right now, the only way I have found to do that is in the New Record page for MyTable, I use a lookup wizard for each field. For example, for Test, the lookup wizard displays a drop down based on the Test field in Master.
As you can see in the image, the prompt for selecting a value for the Test field shows all of the fields for all of the records in Master. However, only the Test field can be selected.
So the problem is that the user has to go through this same process for each field - test, section, questions, notes, etc. This is kind of time consuming. It's also awkward in that for each field being added in MyTable, the display menu reopens and the user has to scroll through all records to find the one again that they wanted to import from.
If there was a way that the user could just one time find the record they want to import from among all the records in Master and import all the fields that they want to import from that record, that would be so much easier.
An additional problem is that MyTable will contain more fields than the record in Master. In addition to test, section, question#, notes, it might include firstName, lastName, myNotes, Comments.
Is there any way then to import multiple fields from one record in Master into MyTable in one shot?