Its' quite a long question but I've explained it the best way I know how
I have two subforms within a main form.
Each of the subforms are not directly related at the table level.
one subform is for project payments, the other is for the project bank details.
Because each project can have several payments, this means that there can be several records for both subforms.
On the bank Details subform I've made the PK id visible so just for example sake, if there are three records, the ID's might be 01,02,03.
because I need some way of knowing which bank details go with which payment ive updated the BankID PK on the payment table so that I can also show the BankID on the payment subform.
To show the specific bank details that were used for the specific payment the user will use the navigation buttons until for example both the payment and bank subform say 01.
What I want to do is have a combo box on the payment subform that will, for example, list the three records (01,02,03) but when I try this it gives me all of the bank PKs within the table (3000 or so) instead of limiting it to the three records within the specific project
Does any one know how to limit it to just the related records within the combo box?
Any help would be appreciated.