Closed

Assistance with MS Access Database Creation

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.

Skills: Database Programming, Excel, Microsoft Access, SQL, Visual Basic

See more: microsoft access support ending, microsoft access tips and tricks, microsoft access tutorial, microsoft access 2016 help, microsoft access 2013 help, microsoft access help phone number, microsoft access help forum, microsoft access support, convert ms access database exe, connect google map ms access database vb, code store text form vb project ms access database, cheap ms access database design, backup restore ms access database vb net windows application, attendance ms access database, access ms access database manually

About the Employer:
( 0 reviews ) Italy

Project ID: #16414701

29 freelancers are bidding on average €26 for this job

schoudhary1553

Greeting, I have understood your Assistance with MS Access Database Creation task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Database More

€100 EUR in 2 days
(226 Reviews)
7.3
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects I've developed for Ms Access/Excel/VBA projects. I'll do your small Ms Access project More

€29 EUR in 1 day
(47 Reviews)
6.1
alaeddindhahri

Hi, I'm a senior databases developer. I have checked your file and I'd like to help you get this done. However, your tables and relationships are correct but in a recursive relationship Access Relationship Manager can More

€34 EUR in 1 day
(62 Reviews)
5.5
€34 EUR in 1 day
(30 Reviews)
5.9
royalcalif

Your task is ready to deliver. PM me. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier More

€30 EUR in 1 day
(75 Reviews)
5.8
jawadaman

Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines More

€29 EUR in 1 day
(84 Reviews)
5.8
sergey12345

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.

€23 EUR in 2 days
(29 Reviews)
5.1
jonathanpradas

Good day. I would like to help you on your project. I have been using Ms access and sql in general so this kind of problem should be easy for me. Feel free to message me so that we can talk more about this project. Tha More

€20 EUR in 1 day
(46 Reviews)
5.1
katiewells3

I am a business analyst with 15 years professional experience working with Access. In order to achieve what you are after you will need to modify the underlying SQL in the table to have an OR condition in the join - i More

€23 EUR in 1 day
(21 Reviews)
4.7
whitehorsetechn

Greeting, I have understood your Assistance with MS Access Database Creation task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Database More

€50 EUR in 1 day
(12 Reviews)
5.0
VBAautomation

I am ready to support you right now. I can fix this issue easily. the main reason behind this can be the relationship issue. many to many not managed correctly. I can develope your complete project within a sort time More

€24 EUR in 1 day
(11 Reviews)
4.2
€29 EUR in 10 days
(4 Reviews)
3.1
Carlosemadrizmor

Hi. I can help you. Only doing CLICK, code is not necessary. I can help you any time you need , even after close this bid. I feel happy about that,.

€14 EUR in 1 day
(3 Reviews)
3.1
everettb

A proposal has not yet been provided

€29 EUR in 1 day
(1 Review)
2.8
Bl1tz1t

Hello! I have some years of experience in sql data modeling and I believe I can help you with your problem. Best Regards

€20 EUR in 1 day
(1 Review)
2.1
MikeeG

Ciao I have worked with MS Access for 18 years and would be more than happy to assist you where needed. Sounds like you just need a guide as you learn and make updates to your database which I am more than happy to More

€13 EUR in 1 day
(1 Review)
1.0
rmseverson

You just need to change your query slightly. Use this SQL statement and then change your form appropriately. You unfortunately cant make this kind of statement with the table query designer, it is purely SQL only. B More

€19 EUR in 1 day
(1 Review)
0.6
rayyankabir

This is not the way to show all the data associated to one matching key. If you see the join is set on one field (go to design view, select the subform and see the Data tab property) where in you want the data based on More

€20 EUR in 1 day
(1 Review)
0.6
€16 EUR in 2 days
(0 Reviews)
0.0
Adoundis

I've create (design and implementation) several complex MS Access applications. What you are looking for is very simple and potentially could be a very flexible tool for you to work with. I can create a sample for More

€29 EUR in 1 day
(0 Reviews)
0.0