Hi all,
I have two forms for two different tables that I want to link through a command button. Pretty simple.
The one form describes the results of an event.
The other form describes the event itself.
I want to set it up so that a user entering data on the form that describes the "results" can press a command button to select the "event". This would open the "event" form where they can scroll through the records, select the one that they want, and then click another button to return to the "results" form which will now have the correct "event" foreign key.
I think this is pretty simple, although it is a little difficult to describe. I tried to google an answer without much luck, so maybe someone can help me here.
Thanks in advance!