I'm having an issue with populating some data into a form List Box. I have created a many-to-many relationship using a linking table and the form I have created displays that data fine. I used https://www.youtube.com/watch?v=GYawYO8u3_s to get this far. I would now like the form to display data from a further table that is linked.
In my example, the form is based on tbl_DummyEpisode and displays data from tbl_AdversariesTest. The Species value in tbl_AdversariesTest is a foreign key linked to tbl_SpeciesTest. In the form, the SubForm contans the relevant field mapping and the Adversaries List Box contains the SQL lookup code (the Data field is set to AdversaryID).
Code: Select all
"SELECT "Name", "ID" FROM "tbl_AdversariesTest""
Hopefully, this'll be an easy one for someone that knows what they're doing