many-to-one situation

[IrenaY]

I have a database that is based on TBL_Project (housing project details),
with a PK Project_ID, autonumber. However, one project may have more than one
name that users will be searching on, and all names should be active, so once
I realized this, I pulled the names out of TBL_Project and now they're in a
new table - TBL_Project_Name, with Project_Name_ID as the PK, Project_ID as
the FK, and a field Project_Name (text field housing the name). When I need
to enter a new Project name, Project_Name and Project_Name_ID are populated,
but I cannot get the Project_ID field to populate because I'm not entering
any other data to TBL_Project. I need to have this Project_ID field
populated before I can populate any other tables in the realtionship.

Anyone offering ideas?

Irena

 

[Steve Schapel]

Irena,

You will need to include another field in the TBL_Project table. If
there's nothing in reality, just add something arbitrary. For example
ProjectActivated, Yes/No data type, put a checkbox on the form, so when
you tick the checkbox it will trigger the AutoNumber entry for a new
record in the Project_ID field. Then you can have a subform on this
form, based on the TBL_Project_Name table, so when you enter a project
name, the applicable Project_ID will automatically go in.