The OP is not clear about what type of record he is creating in which the
four positions are filled. I see now that I made an assumption that it was
some sort of scheduling thing, and that a new record would be created
periodically. That assumption may not be warranted, but neither is your
assumption about the structure, as the database purpose is not clearly
defined.
What is most definitely not warranted is your continually mistaken belief
that these newsgroups are for anything other than free peer-to-peer support.
When you told the employee the design was wrong, then posted a sketchy table
structure, I wondered if you were heading in the direction of a solicitiation.
I will repeat: these newsgroups are not your personal advertising forum.
Commercial solicitations are inappropriate. If you haven't learned that by
now there is no reason to think you can handle Access.
Steve wrote:
You would use a combobox to enter EmployeeID in the form based on
TblScheduleEmployeePosition. The rowsource of the combobox would be a query.
To create the query, go to the list of queries and select new. One of the
options would be the Unmatched Query Wizard. Use the wizard and select
TblEmployee then in the next step select TblScheduleEmployeePosition. You
want the query to return all EmployeeIDs in TblEmployee not found in
TblScheduleEmployeePosition. In your query, make the first column EmployeeID
and the second column the following expression:
Employee = [LastName] & ", " & [FirstName]
Set the following properties in the combobox:
RowSource NameOfTheQuery
Bound Column 1
Column Count 2
Column Width 0,2
If this project is above your ability, I can help you. I provide fee-based
help with Access, Excel and Word applications. My fee to help you would be
very reasonable. If you want my help, contact me.
Steve
Thanks Steve. I'm beginning to think this project is above my ability, but
I'm willing to challenge myself. I just don't get how to 'make the row
[quoted text clipped - 89 lines]
.
--
Message posted via
http://www.accessmonster.com