One Form w/2 Recordsources

[newestAF]

It's been a while since I've posted here. Hoping to get some great help as I've always gotten here. I have 4 tables with delete queries and a few mismatch queries. Table 2 has a list of offices and table 3 has a list of the HR offices and contact information. Each office is assigned under a servicing HR office. I want to create a form that shows the record information of Table 2 with a drop down box linked to Table 3. When a user pulls up an Office record, I want them to be able to select an HR office (via combo box) on the form to assign that record to and then add all fields of information to Table 4. I don't have a clue of where to start.

 

[TheAceMan1]

How are ya newestAF . . .

You need to establish a relationship between [blue]HR offices[/blue] as the parent table with [blue] offices[/blue] as the child table.

See: Defining relationships between tables in a Microsoft Access database


See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[boblarson]

And to follow up on TheAceMan1's post - you would use what that for a main form/sub form. It doesn't all go on a single form. When you have a one-to-many or many-to-many relationship you need to use a main form for the one and a subform for the many. In the case of many-to-many you use the main form for a single record of one side of the many to the many side of the relationship to that one record.

Hope that helps as well.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com