KaylaHansa
New member
- Local time
- Today, 07:06
- Joined
- Mar 22, 2020
- Messages
- 18
Hello everyone! I really need to do this but I'm not sure if it's even possible. (I'm new to Access and databases in general). So I have a main table, called AllCustomers. I have several other tables (ex: AlarmCustomers, CameraCustomers, ect). The main AllCustomers table primary key has a one-to-many relationship with these other tables. Each sub table has it's own fields (ex: AlarmCustomers has an "AlarmID" field). I know you are probably thinking why not have all the fields on one table, but please do not tell me alternative ways to structure the database. I cannot make changes to this and have to work with what is there. What I'm trying to figure out is if it is possible to create a query or form that displays the records in a list without combing based on relationship. Here's what I mean:
Normally when creating a query that combines the tables the results will look like this:
CustomerName(1) AlarmID CameraID
CustomerName(2) AlarmID CameraID
I need it to look like this:
CustomerName(1) AlarmID
CustomerName(1) CameraID
CustomerName(2) AlarmID
CustomerName(2) CameraID
Each customer may have several alarm and camera IDs. So the customer should be listed more than once, but each individual AlarmID or CameraID should only be listed only once. Is this possible to do, despite the seemingly opposing one-to-many relationship?
If you know how and have any input, it would be incredibly helpful!!!
Normally when creating a query that combines the tables the results will look like this:
CustomerName(1) AlarmID CameraID
CustomerName(2) AlarmID CameraID
I need it to look like this:
CustomerName(1) AlarmID
CustomerName(1) CameraID
CustomerName(2) AlarmID
CustomerName(2) CameraID
Each customer may have several alarm and camera IDs. So the customer should be listed more than once, but each individual AlarmID or CameraID should only be listed only once. Is this possible to do, despite the seemingly opposing one-to-many relationship?
If you know how and have any input, it would be incredibly helpful!!!