Struggling to link pop-up form to main form
Hello,
I’m struggling to properly link the selections made in a pop-up form to the main record.
I have set up the table “UNCategories” to house all the selections from the pop-up form … AND I have a main table, “RTTT,” where “TermID” is the primary key.
TermID is a foreign key in the UNCategories table … and UNCategoriesID is a foreign key in RTTT (the main table).
As you can see in the pic all the way at the bottom, the table UNCategories is registering the results, but when it comes to the record they relate to, nothing but zeros appear! So, I have a bunch of results, but no idea which record they belong to.
Any help would be greatly appreciated! If you need further screen grabs, please let me know.
Hello, I’m struggling to properly link the selections made in a pop-up form to the main record. I have set up the table “UNCategories” to house all the selections from the pop-up form … AND I have a main table, “RTTT,” where “TermID” is the primary key. TermID is a foreign key in the UNCategories table … and UNCategoriesID is a foreign key in RTTT (the main table). As you can see in the pic all the way at the bottom, the table UNCategories is registering the results, but when it comes to the record they relate to, nothing but zeros appear! So, I have a bunch of results, but no idea which record they belong to. Any help would be greatly appreciated! If you need further screen grabs, please let me know. Read More