I have two tables. A batch record that denotes a bank deposit. I also have a table of claims for patients where the money from the batch needs applied. I need to be able to select a batch, and create a mechanism to search the claims table for a patient (this would be my lookup for available records) and associate it to the batch record. The association is one batch to many claims (though there is times that there is only one claim). I cannot figure out how to create the link between these two, especially when there is not a link to create a relationship. Thanks in advance for your help.