I admire your determination! I remember when I was tackling a similar challenge, trying to link different tables in my database seamlessly. It can definitely be a head-scratcher at times!
Regarding your form not populating, have you checked your query or data source? Sometimes a small glitch...