So, the project I’m working on is an application that contains several customers. The main tables I have are contacts, drivers, and customers. Each of these tables has a Customer ID that connects them to each other. This means that a customer can have one or more contacts in their company, the same goes for drivers. Drivers, in addition to the customer ID that refers to the company, have their own driver ID by which they are distinguished. When a customer logs in, he can see details about his company (details), details about his contacts in the company, and details about his drivers. I’ll send you a picture of what that looks like now.
Now, when the client clicks on a driver in the Drivers table, here where it says Belgium, RMPD100, and so on… it opens up data such as company details, driver details, and the form. The form is located in the Posting Certificate table which is linked to these first 3 tables that I listed at the beginning.
When they click on something offered — pl, be, rmpd100 — in addition to what I mentioned, I want to see the details and contacts of that company (from the contact table, the only difference is in the function since I have the function director and the function contact). I don’t know how to display that.
This is when I clicked on the driver application PL, you see that nothing is displayed from the contact table, and I need the details from that table to be displayed. It should be like a dropdown, where the person filling out the application will be able to choose which contact they want to display — but only those contacts that are linked to that customer.
Tell me how I could solve this, I would be very grateful. I hope you understand my question.
