Record relationships in forms

[avarusbrightfyre]

Problem:



I'm constructing a database for my wife so she can keep track of a lot of the information for her work. She needs to keep a master record with all the contact info and such for her clients, but she also needs to keep records of payments, work schedules and then another section for changes to those items.

Right now I have four tables set up (Main Table, Payment Schedules, Work Schedules and Change Orders) each with a field labeled "Project Name" and each table linked by that field.

I need to be able to list (on the form) all records that relate to a specific project name (using a drop down menu at the top to pull the record from the main table), and give the user the ability to add or edit them as desired. Right now it just shows everything on the table the form is linked to, and that will get hard to look at once a bunch of entries are entered.

[avarusbrightfyre]

I stumbled on the idea of using sub-forms within the form I'm using that relate to the main table (it's all in the sub-form wizard). I just wish that I could have the form separate (like a pop-up) and brought up by a button so the form itself doesn't have to be so large. Any ideas?

[dcrake]

Use the subform as a normal modal popup form using OpenArguments to filter the data in the popup form.

David