Looking up miltiple names

[phillsheen]

Hi,
Ive got a small problem in a form on my database. I have a main form called 'Members' which stores details of all our members. With in this form I also have a subform named 'Payments'. There is a relationship between the forms Membership>Description and Payments>BankDescription as one to many so one member can have many payments. This form also has Linked Master and Child fields of Membership>Description and Payments>BankDescription.

So this basically gives me a membership form that shows all the payments that member has made in a subform when I put the banks description in the description field.

Now this is where Ive come across a problem. We've changed banks and now there are two bank descriptions per person so Ive added a new field in the members form 'Description2'. the new bank payments will still be entered into the 'Payments' table so I need the subform to now show two lots of information in one subform (this subform is in table view by the way.)

Any help would be great!

Cheers
Phill

 

[pbaldy]

I would expect the relationship to be between a MemberID field in each table. Don't you record the member who made the payment in the payments table along with the other payment info?

 

[phillsheen]

I dont record the members info in the 'payments' table becasue the 'payments' table come straight from the bank so I cant change the format. All ive done is relate the bankdescription field which is the same for every member to the Description in the membership form.

As far as the relationships goes the way I have done it seems to work for one description but not two. I have no idea if this relationship is the best way to do it or not but the Description field in the members form in not a unique field, there will be duplicates if that makes and difference?

Thanks for the reply.

Phill

 

[phillsheen]

Anyone else know how I can achieve this result? I am finding myself going around in circles at the moment. I have tried linking the two fileds under the linking master and child fields under the properties of the subform but to no avail.

Any help would be fantastic as Im loosing my hair rapidly

Cheers
Phill

 

[phillsheen]

Ive attched a picture of the database screen as it might help with description which was pretty hopeless to be fair.

In the top right corner we have the description which is typed into the main members form which then shows all the records in the subform. All that data in the subform is imported from a file from the bank. The second description (the one with the text label in red) is the new bank description. I need to know how I can get the subform to show all the records for both of those descriptions.

How this makes my problem a little clearer.

Cheers
Phill