I created two table (company(company_id as the key and project (project_id as the key) these two tables is related (one to many relationship). I want to create a form with a subform of the project. I tried doin it using the subform wizard but it didn't work coz the error says it would create duplicates, What the problem here? Im using access 2002.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
creating subforms
- Thread starter lara19
- Start date
Check the following:
Company_ID is the primary key of the company table.
Project_ID is the primary key of the project table.
You will see a Key icon next to their names in design view.
Company_ID is used as a common field in the Project table.
You may also want to set this connection up in the Relationship table and turn on Referential Integrity.
Create your main form from the company table, and another form from the project table.
If everything is set up correctly, the wizard should work.
Neil
Company_ID is the primary key of the company table.
Project_ID is the primary key of the project table.
You will see a Key icon next to their names in design view.
Company_ID is used as a common field in the Project table.
You may also want to set this connection up in the Relationship table and turn on Referential Integrity.
Create your main form from the company table, and another form from the project table.
If everything is set up correctly, the wizard should work.
Neil
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question