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.