The issue was that
Field3
did not result in any listed table values, so instead of another
INSERT INTO
SQL statement, I made a form for
TableB
because I needed that, anyway.
TableB
uses a combo box that hides a
Field4
and lists
Field3
content from
TableC
. Filling out the form allows for the entry of
Field4
into
TableB
that I may then
INSERT INTO
TableA
. I think that I needed
TableC.Field4
selected so that
TableB.Field3 = TableC.Field3
worked. In either case, I think I may run a SQL Query for
TableA
based on
TableB
contents. —
JMK 9 mins ago