Adding multiple data from the same source table (1 Viewer)

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
 

Attachments

  • relationships_db.pdf
    68.4 KB · Views: 85

pbaldy

Wino Moderator
Staff member
Local time
Today, 04:50
Joined
Aug 30, 2003
Messages
36,118
For starters your orders table is not normalized. There should be a related table for mechanics on each order, with fields for order ID and mechanic ID and any other related fields (start/end times for each?). To your question, your report would be based on a query that joined the mechanics table to the orders table, enabling you to return the mechanic name.
 

Users who are viewing this thread

Top Bottom