houstonswamp
New member
- Local time
- Today, 04:50
- Joined
- Mar 12, 2019
- Messages
- 5
Hello there,
I'm trying to set up a form where multiple mechanics can be put on one order.
When I set up a form everyting goes right, I can manage to display the MechanicName instead of the MechanicID. After all I'm trying to set up a report with the same data, but my query only contains the MechanicID. I have the feeling that I'm doing something wrong fundamentally, I added a .PDF with an overview of the relationships and tables.
I also read the it is evil to use lookups in tables, but how do I choose my mechanic in the table orders then?
Hope somebody could help me, thanks in advance.
Houston Swamp
I'm trying to set up a form where multiple mechanics can be put on one order.
When I set up a form everyting goes right, I can manage to display the MechanicName instead of the MechanicID. After all I'm trying to set up a report with the same data, but my query only contains the MechanicID. I have the feeling that I'm doing something wrong fundamentally, I added a .PDF with an overview of the relationships and tables.
I also read the it is evil to use lookups in tables, but how do I choose my mechanic in the table orders then?
Hope somebody could help me, thanks in advance.
Houston Swamp