Associating records from one table to a record in another table 1

[tekbro]

I have what I think is an interesting problem.
I've created form1 which is based on table1.
I have another form2, which is based on table2.
I want to associate only certain records in table2 with a particular record in table1.

Hopefully, the result would be this: As I page through the records in form1, the object that displays those certain table2 records would show only those table2 records associated with the current table1 record being displayed in form1.

I've goofed it all up, but was hoping one of you nice folks could point me in the right direction. None of my handy training manuals seem to address this particular scenario.

I thought I could do this with subforms, but I'm not quite getting it.

-Tekbro

 

[randysmid]

Hi,
I have a sample of this in my free database. The database is free, and is about 2.2MB in zipped format. I have a form called Invoice Maintenance, and has a sub-form that links the invoice details to the Customer table. Just send me an email if you want a copy of the database.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association