neilsolaris
Member
- Local time
- Today, 18:52
- Joined
- Apr 19, 2020
- Messages
- 114
Hi,
I have a form which is working great, which I'm very happy with. I'm attached a sample database in case it helps to put my question in context.
Basically, I posted for help regarding my main form, and arnelgp suggested adding a subform below, showing the summary. I'd like to incorporate his idea, but with a tiny difference. I'd like the subform to show details relating to just the musician and job number, linked to the info on the main form (I hope that makes sense!).
So, if you open F_Payments, the first entry is Amy Jones, engagement number 1000. She has one other entry relating to that engagement number. Therefore, below I'd like the subform to list both entries for Any Jones and engagement 1000.
I've played around with it, but I'm not sure how to make it work. Ideally, instead of doing it for me, would it be possible to talk me through the process please? That way I can learn for next time.
Many thanks for your help.
I have a form which is working great, which I'm very happy with. I'm attached a sample database in case it helps to put my question in context.
Basically, I posted for help regarding my main form, and arnelgp suggested adding a subform below, showing the summary. I'd like to incorporate his idea, but with a tiny difference. I'd like the subform to show details relating to just the musician and job number, linked to the info on the main form (I hope that makes sense!).
So, if you open F_Payments, the first entry is Amy Jones, engagement number 1000. She has one other entry relating to that engagement number. Therefore, below I'd like the subform to list both entries for Any Jones and engagement 1000.
I've played around with it, but I'm not sure how to make it work. Ideally, instead of doing it for me, would it be possible to talk me through the process please? That way I can learn for next time.
Many thanks for your help.