silentwolf
Active member
- Local time
- Yesterday, 19:12
- Joined
- Jun 12, 2009
- Messages
- 575
Hi guys,
Would like to get some input or thoughts about following situation.
Background of the Database/Situation:
1. A Company gets an Order to do some Work(maintenance) for some Bath/Sauna Equipments
2. There are one or many different Equipments with different Manufacturers in one Order.
3.Each Equipment needs Parts for completion of this maintainence or repair tasks.
Changing all Seals or need a new Pump, Cables and so on...
4. If these Parts are required to complete these maintainance tasks we need to find those parts quickly and order them from the
manufacturer.
5. Each Manufacturer has given us a Partlist and as you can guess there are several thousands of it wich of course not all of them are
relevant for our "Flexline Superbath" maintanince work.
For better understanding I did include the Database Structure.
Workflow:
1. In the Orderform I did create a sfm_AuftragModelle
gives me all the Models related to the Order
2. A button on that subform to open only the parts for that relevant supplier
3. in frmSupplier1Pop is a textbox to search for a part
4. I created a seperate table tbl_ArtikelModell as a linked table to tbl_Modell & tbl_Artikel
in Order to save the selected Item to the appropiate article with a many to many relationship
So the Art_ID = 1 can be used in Mod_ID = 5, 15, 22
In my sfm_Auftrags Modelle (included as a picture) I got a button with three dots... that opens
the frmSupplierPop
I do the search and press Ok which fills thanks to you guys the ModelID
and the Art_ID into tbl_ArtikelModell
So finally to my question
When I found for example "Dichtungsring f. Ansaugstück" and added it to my tbl_ArtikelModell by pressing the ok button.
So there will be in later time for Mod_ID = 1 Art_ID, 1,125,12545,33...
what has been added to that Modell.
So how could I switch between all "Articles" and say only those who where already once added to my table tbl_ArtikelModell?
Sorry for this rather long threat!
Can someone give me a hint or solution how to go about this?
Hope it is clear what I am trying to do here.
Many thanks in advance!!
Albert
Would like to get some input or thoughts about following situation.
Background of the Database/Situation:
1. A Company gets an Order to do some Work(maintenance) for some Bath/Sauna Equipments
2. There are one or many different Equipments with different Manufacturers in one Order.
3.Each Equipment needs Parts for completion of this maintainence or repair tasks.
Changing all Seals or need a new Pump, Cables and so on...
4. If these Parts are required to complete these maintainance tasks we need to find those parts quickly and order them from the
manufacturer.
5. Each Manufacturer has given us a Partlist and as you can guess there are several thousands of it wich of course not all of them are
relevant for our "Flexline Superbath" maintanince work.
For better understanding I did include the Database Structure.
Workflow:
1. In the Orderform I did create a sfm_AuftragModelle
gives me all the Models related to the Order
2. A button on that subform to open only the parts for that relevant supplier
3. in frmSupplier1Pop is a textbox to search for a part
4. I created a seperate table tbl_ArtikelModell as a linked table to tbl_Modell & tbl_Artikel
in Order to save the selected Item to the appropiate article with a many to many relationship
So the Art_ID = 1 can be used in Mod_ID = 5, 15, 22
In my sfm_Auftrags Modelle (included as a picture) I got a button with three dots... that opens
the frmSupplierPop
I do the search and press Ok which fills thanks to you guys the ModelID
and the Art_ID into tbl_ArtikelModell
So finally to my question
When I found for example "Dichtungsring f. Ansaugstück" and added it to my tbl_ArtikelModell by pressing the ok button.
So there will be in later time for Mod_ID = 1 Art_ID, 1,125,12545,33...
what has been added to that Modell.
So how could I switch between all "Articles" and say only those who where already once added to my table tbl_ArtikelModell?
Sorry for this rather long threat!
Can someone give me a hint or solution how to go about this?
Hope it is clear what I am trying to do here.
Many thanks in advance!!
Albert