Autofill field from previous fields entered

[ssanfu]

The only time Look-up fields in tables are somewhat useful (IMO) is if you have a dB that only you use and you use a form in datasheet view or enter data directly into a table.


Otherwise use a combo box (I think this is what you mean by "a controlled vocabulary") on a form in Single Form or Continuous Form view.
I know of no other database engine other than Jet/ACE that has Look-up fields, Calculated Fields or Multi-Value Fields. So if you convert to another DB engine (say SQL Server, Oracle, MySQL,...) you end up redesigning your db.

[ssanfu]

From Post #1

I would like for Access to autofill the "head coach" field based on the information I entered previously (ie, season, and team).

From Post #11

If you were to do a query from the EntriesT and set season to "147", leave the Coach field blank, set team to "1" and Position1 to "1" you should get Chuck Martin. So what I would like to happen then is when I'm entering in a member of his staff it pulls this information and puts it into the Head Coach field

I tried a query with:
Season - 148 (2016)
Team - 108 (Houston)
Position1 - 1 (Head Coach)

2 records were returned: Chuck Martin and Tom Herman. How would I know which coach to enter in the Head Coach field? What am I missing?
Here is the query I tried

SELECT EntriesT.Coach_FK, EntriesT.Season_FK, EntriesT.Team_FK, EntriesT.Position1_FK, EntriesT.League_FK
FROM EntriesT
WHERE (((EntriesT.Season_FK)=148) AND ((EntriesT.Team_FK)=108) AND ((EntriesT.Position1_FK)=1));

[jucooper1]

I am so sorry guys, I thought everyone stopped responding, I didn't see the second page of comments.

That's exactly what I do, and its really helpful for me to have those look up fields.

I ran that same query and I only got Tom Herman. I don't know why you also got Chuck Martin.