Input Form from multiple tables

[hobman]

Hi, I have a big problem. Here is the business rule, I am trying to track meeging request(MR) made. A meeting request is made by a manager,MR can include many analysts, and MR involves 1 project. I am trying to creat an input form for the MR table (tblMR) The input form is going to contain all the fields from the tblMR except the manager_ID and and the Project_ID, I am also going to have it track which analysts attended the meeting. The problem I am having is in creating the form but having the analyst, manager, project values come from their own tables but after selecting them through combo box or list box, for their values to be entered in the tblMR. Any suggestions will help.

 

[Trendsetter]

The table tblMR needs to have Manager_ID and Project_ID in there as foreign keys so that you can link the two tables (Managers and projects) as lookup tables.
There needs to be a table sya tblAttendees which will have the MR_ID (Which links back to Manager, Project, date....)
plus the Analyst_ID which will store all of the analysts attending that MR
The main part of the form will hold the MR_ID, manager, project, date, timing, location, etc... and the sub form will hold all of the attendees in a continuous form format.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[hobman]

Trendsetter, Thank you. I the Manager_ID and Project_ID is a foreign key in the MR table. I just didn't think selecting them would be possible from the MR table. So that is why I am tryig to make their control source thier own table.