Hello fellow developers.
I am nearing completion of my project, but have one challenge remaining and was hoping someone could point me in the right direction.
The challenge includes three tables, but one form; _Transaction (table), _Sender, (table) and _Receiver (table). The main form is Transaction (form). On the Transaction form there are two drop down boxes, one for Sender ID linked to the table _Sender, and one for Receiver ID linked to the table _Receiver. This allows me to uniquely identify with Sender and which Recipient belongs to a specific Transaction.
My problem is that this is not very user friendly and will not work once there are many Senders and Recipients. I am trying ot think of a way to allow the user to select the Sender from one table (perhaps by searching for a name, if the name and id matches allow the user to select this), then continue to choose the Recipient from another table, then link both IDs to the Transaction and continue to fill out the transaction form.
Not sure if this makes sense, but if anyone has any inputs it would be much appreciated.
Thank you in advance,
Tom