I am creating a relational database. My expertise is fairly limited but I have managed to create a simple database with several tables and many-to-many link tables joining the tables. I am now a little stuck because I want to show links between records in a table to other records in the same table. When I display this data in a form with a subform, it shows the records that match Key 1 but not records that match Key 2. Ie I can see that John is linked to Steve and Matthew but I cannot see that he is linked to Allan because he appears on the second foreign key in the link table rather than the first.
I'm just looking for some very simple help here. I don't want any confusing VBA coding. I need you to be able to show me exactly how you did it so that I can replicate the steps myself later.
Although a simple task I am keen to develop a relationship with a competent access database creator potentially for future tasks.
29 freelancers are bidding on average €26 for this job
Hello, If you want just to view these records, you can use the method implemented in the demo. But this method only for see the records. If you need edit/add records, then without VBA it will fail.