How to create a Master Table to populated associated data multiple times

[Ravindra]

Hello all,



I am trying to create a database of Work order Management System.

The Work order is unique for a specific build of vehicle and is associated with Description.

As an example :

Build 1 : Operation Description > WO1
Build 2 : Operation Description > WO2
BUild 3 : Operation Description > WO3

I wanted to use the "Operation description" and get all the associated work orders in all build of vehicles.

Thanks,
Ravindra

[ranman256]

run a make table query using only those fields.

[ssanfu]

Welcome to the forum.


Your question is very vague. It would help to know a little about what you are trying to do and about your dB.

Are you wanting a search using all or part of an operation Description and get the WO number? (table names and fields would be helpful)

[Ravindra]

Hello all, I am trying to build a database tool for Work order Management. Need your inputs and Suggestions on the design of database.

There are 3 (C1,C2,C3) configuration of systems and the Tasks are mostly Identical, however the work order # is Unique for each configuration.
These work orders are reviewed by the assigned worker and feed in information(eg: Comments).

Work Orders Table

Task Work Order Configuration Status Comments
Task1 WO1 C1 Cancelled Cannot be Worked - Constraints
Task1 WO2 C2 Open Can be Worked
Task1 WO3 C3 Open Can be Worked
Task2 WO4 C2 Open Cannot be Worked - Constraints
Task2 WO5 C3 Open Cannot be Worked



We get a daily data from SAP with Work Order Open / Close status for all configurations in a single file. In this context:
1. How do I create a automated daily sync to update the Work Orders status and also add new work orders.
2. I have to retain all other data in the table.


Constraints Table

Task No. of Constraints Configuraiton WO
Task1 2 C1 ??
Task1 3 C2 ??
Task1 4 C3 ??
Task2 5 C3 ??

We get a daily information of no. of constraints for all the tasks. There is no associated work order (WO) in the report.
I wanted to create a master Task list , compare it to Work Orders table and retrieve the respective Work order.

1. How do I create a automated daily sync to update these Constraints and retrieve the relevant Work Orders.