Show records with one same field value

[steve042]

Hello,

I'm a beginner trying to build a simple database for work. I'm trying to track the performance of bonds from month to month, in this case January-April. Each bond has a serial number called Serial_ID, but we wanted to create a record for each month we own the bond, so we created a primary key combining Serial_ID and start date called Serial_Start_Date. So if we own one bond, its January record would have a primary key of "4553123A 2013-01-01" and February would be "4553123A 2013-02-01". I created a form that allows a user to select one individual month's bond and display that month's return. However, I'm struggling to find a way to create a form that allows me to just select the Serial_ID and display the four month's records. Right now there is only one table in the database.

If this is confusing I can answer any more questions.

Thanks.

[Sibtain]

filtered on the basis of month

[ssanfu]

It is unclear what fields are in your table.
Do you have one field "Serial_Start_Date" AND fields for "Serial_ID" & "Start_Date"?

[steve042]

I got it to work. I had to create a table with a list of Serial_IDs (removing duplicates). From there I just had to link the tables and create a form with a subform in it.