One to Many Relationship with a form and a table

[Kristi]

Hello,


I cannot seem to figure out how to do this. I have created a database where I will track Agent's Contact Information and where we will track Transactions processed. I want to link each transaction to the appropriate agent and then on the Agent Record form, would like a list of their transactions. I know it has to do with relationships and subforms, but everything I have tried is not working.

I have the Agent ID set up as the Auto-Number (long integer) and then I have a field in the Transaction Record with an Agent ID (as a number, long integer). I've created a relationship between Agent Record and the transaction record (Agent can have many transactions). Now I want to create a subform so that when I pull up the Agent's record, I can also see their transactions.

Any help would be greatly appreciated.
Thank you,
Kristi

[June7]

Main from bound to Agents, subform bound to Transactions, Master/Child Links properties of subform container control set to the associated PK/FK fields.

If you want to provide db, follow instructions at bottom of my post.

[Kristi]

EquityProfessionals2015Test.zip

I hope this works. I know it's an easy thing, but I am drawing a blank.
Thank you,
Kristi

[June7]

You have not created a form/subform arrangement. Can make TransactionTrackingF (or the table or a query or another form) a subform on AgentInfoF. https://support.office.com/en-US/Art...rs=en-US&ad=US

[cbende2]

Hey Kristi, Make open up AgentInfoF and make a subform with TransactionTrackingF. Walk through the wizard, it worked perfect for me. You have everything set up correctly. Maybe you're not seeing that the TransactionTrackingF subform will only display 1 of many records at a time. You need to use the record selector at the bottom of the subform to scroll to the next Transaction that is related to the agent! Hope that helps!

[Kristi]

Thank you so much! I did get it. I knew it was something small. hahahaha