Forum Discussion
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.
Hi,
1. > UNCategoriesID is a foreign key in RTTT (the main table)
that you don't need and should delete.
2. The text box with caption "TermID" in the pop-up form contains an expression=calculated control=unbound. Therefore, it's value doesn't get saved in the table. You have to assign the TermID value to a bound control or to the table field when you open the pop-up, or you have to save the TermID when you close the pop-up. The first one is better. Either way you will need VBA or a macro to do this.
3. How do you open the pop-up form?
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. NürnbergHiiii Karl,
Hope all is well. I was actually coming here to write that I figured it out. I have no clue how I did it!
I remembered something about a default line. Anyway, the screen grabs can illustrated what I'm too clumsy to explain.
As you can see, what I have selected from the check list is, indeed, registered in the UNCategoriesT table, and those selections appear next to their corresponding TermID.
Oh, and I also removed the UNCategories field from the RTTT table as recommended. It is no longer a foreign key in the RTTT (main table). Thx!
