R
rstirlin
Hi, I am new to this forum & quite new to trying to programme in Access.
I am trying to design a small database where I can store info on articles on computer.
Specifically, I am currently stumped on a solution re testing an intersection table for 2 one-to-many tables to see if the 2 specific records from those tables are already related in the intersection table or need a new entry. (I basically want to have simple forms for each of the one-to-many tables open on their relevant record & then either open the intersection table's form to add a new relationship if none exists or give myself a message if it already exists.)
I am trying to design a small database where I can store info on articles on computer.
Specifically, I am currently stumped on a solution re testing an intersection table for 2 one-to-many tables to see if the 2 specific records from those tables are already related in the intersection table or need a new entry. (I basically want to have simple forms for each of the one-to-many tables open on their relevant record & then either open the intersection table's form to add a new relationship if none exists or give myself a message if it already exists.)