How to select data fields from tableA to auto populate fields in tableB

[DevMan1]

I have some questions regarding on how to set things up to select data fields from TableA to auto populate some data fields in TableB. Thank you in advance for any help that you can provide on this.

TableA has the following data fields (for employee availability information)
-EmpAvID
-EmpAvDate
-EmpName
-EmpHrsTotal (total hours available for the date)
-EmpHrsWrk (hours worked)
-EmpHrsAvailable (hours available = HrsTotal-HrsWrk)
-TaskName

Data will be created in TableA first to contain records for various dates and related info such as employ name, total hours, hoursWrked, hoursAvailable. TaskName will be populated later.

TableB has the following data fields:
-TaskID
-TaskName
-TaskDate
-TaskHours
-EmpName
-EmpHrsTotal
-EmpHrsAvailable

Requirements:
- After a new record is created for a new task with TaskName, TaskDate, and TaskHours (in TableB), the user need to be able to get a list of available EmpName/EmpAvDate/EmpHrsTotal/EmpHrsAvailable available (from TableA) for the specific task and date.
The selection criteria are: EmpAvDate=TaskDate, EmpHrsAvailable>=TaskHours.

- After the user select an EmpName/EmpAvDate/EmpHrsTotal/EmpHrsAvailable from the select list, the data fields in the TableB and also TableA are set as follow:

In TableB,
EmpName = EmpName from selection list
EmpHrsTotal = EmpHrsTotal from selection list
EmpHrsAvailable = EmpHrsAvailable from selection list

In TableA,


TaskName = Taskname from TableB

How can these be implemented? Using a como box (for EmpName) in a FORM for TableB?
How can the TaskName in TableA be set equal to TaskName in TableB?

I hope that the information provided is clear enough.
Any help are greatly appreciated!

[burrina]

This sounds like a typical Mainform/Subform design. If the tables are linked correctly, then you should be able to populate your data.
Example: Main form contains Employee Info.
Subform contains the Details.i.e. Hours,etc...

HTH

[DevMan1]

Burrina,

I am a new Access 2010 user. Could you please provide details on how to implement the Mainform/Subform that you suggested?

Thank you for you help on this.

[burrina]

You have TableA and TableB. So you have a Main form that uses TableA and then the Subform uses TableB and the two forms are Linked by Master/Child with the Primary Key.
If this does not make sense to you. Please do some research on database design and read some books on Access.
Here is an excellent link for examples: http://www.databaseanswers.org/data_models/
HTH