How do I enter data into one table only if a record exists in the primary table

[WANNABE]

and and there is no primary data in the primary table then prompt for it to
be created>>>

I have 2 tables an employee table and a projects table, a one to many
relation from employee to projects on empid. Employee table primary key is
empid (autoNumber), there is also a userid field which when an employee is
entered has a default setting that pulls in the network user ID
<environ("username")> I'm trying to create a form for project entry and
update. The form has all project table fields including empid, and an
unbound field named userid which is set to default to environ("username").

I am trying to build a query on the tasks.empid field default value to
assign
the empid field to the emp.empid field where userid =emp.userid, and I've
tried this >>>

select Emp.EmpID from emp where me.userid = emp.userid

and I get a syntax error. Does this need to be a relation query, and how
would it be constructed?