473,799 Members | 3,148 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Please Help: Production list DB

Hi there,

I wonder if anyone out there can help me.

I'm setting up a database at the moment for a manufacturing company.
In my database I have a table listing all the company products; I have
a related table listing the subcomponents of each product. (The
company makes both the sub components and finished products.) I have a
third table called production list.

In my database I want to be able to select a ‘product' form the
products table and add it to the production list table. I want all
related subcomponents of the selected product to be automatically
added to the production list. As ‘products are added to the production
list table, I select the employee to make the product. Finally I
intend using a query to create editable personal work schedules for
each employee.

I can achieve some of this using multiple queries and a union query to
create the work schedule- but this causes problems because the records
in the work schedules cannot be edited.

I'm not a very experienced Access programmer and I would be very
grateful if someone could advise me on how best to achieve what I'm
trying to do.

Thanks in advance,

Colm
Nov 12 '05 #1
1 1768
co*********@esb i.ie (Colm O'Hagan) wrote in message news:<89******* *************** ****@posting.go ogle.com>...
Hi there,

I wonder if anyone out there can help me.

I'm setting up a database at the moment for a manufacturing company.
In my database I have a table listing all the company products; I have
a related table listing the subcomponents of each product. (The
company makes both the sub components and finished products.) I have a
third table called production list.

In my database I want to be able to select a ?product' form the
products table and add it to the production list table. I want all
related subcomponents of the selected product to be automatically
added to the production list. As ?products are added to the production
list table, I select the employee to make the product. Finally I
intend using a query to create editable personal work schedules for
each employee.

I can achieve some of this using multiple queries and a union query to
create the work schedule- but this causes problems because the records
in the work schedules cannot be edited.

I'm not a very experienced Access programmer and I would be very
grateful if someone could advise me on how best to achieve what I'm
trying to do.

Thanks in advance,

Colm

You might want to start by reading this article:
http://www.mvps.org/access/modules/mdl0027.htm

If all you're doing is finding all the children (parts) of a parent
(an assembly), then you could just search the "components " table for
the FK from parts and then insert all those values into your table.
simple append query...
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1143
by: Dave Stewart | last post by:
I have two projects I am attempting to publish to a production environment. When I run the project and\or pages they run fine on my development machine(the pc with vs.net that the app\pages were written on). When I copy the project to a production IIS web server, the pages load properly on the first load for each page. I have multiple list boxes that are databound programatically on the page load event. Private Sub Page_Load(ByVal sender...
1
1141
by: Dave Stewart | last post by:
I have two projects I am attempting to publish to a production environment. When I run the project and\or pages they run fine on my development machine(the pc with vs.net that the app\pages were written on). When I copy the project to a production IIS web server, the pages load properly on the first load for each page. I have multiple list boxes that are databound programatically on the page load event. Private Sub Page_Load(ByVal sender...
28
3308
by: stu_gots | last post by:
I have been losing sleep over this puzzle, and I'm convinced my train of thought is heading in the wrong direction. It is difficult to explain my circumstances, so I will present an identical make-believe challenge in order to avoid confusing the issue further. Suppose I was hosting a dinner and I wanted to invite exactly 12 guests from my neighborhood. I'm really picky about that... I have 12 chairs besides my own, and I want them all...
1
262
by: Colm O'Hagan | last post by:
Hi there, I wonder if anyone out there can help me. I'm setting up a database at the moment for a manufacturing company. In my database I have a table listing all the company products; I have a related table listing the subcomponents of each product. (The company makes both the sub components and finished products.) I have a third table called production list.
0
903
by: Dave Stewart | last post by:
I have two projects I am attempting to publish to a production environment. When I run the project and\or pages they run fine on my development machine(the pc with vs.net that the app\pages were written on). When I copy the project to a production IIS web server, the pages load properly on the first load for each page. I have multiple list boxes that are databound programatically on the page load event. Private Sub Page_Load(ByVal sender...
13
2151
by: sd00 | last post by:
Hi all, can someone give me some coding help with a problem that *should* be really simple, yet I'm struggling with. I need the difference between 2 times (Target / Actual) However, these times will fall somewhere between a Start & End time Further more, there will be Break & Lunch times between Start & End. Example... Start 08:00 Break start 10:30
8
1704
by: | last post by:
I'm looking for some design guidance on a collection of projects I'm working on. The project involves a bunch of websites constructed out of a collection of user controls. Different user populations with different access rights and "roles" will be visiting the site. I will be using ASP.NET 2.0's membership, roles, and profiles stuff to manage access. User controls need to be visible or not visible depending on user role. In some...
2
1422
by: Designing Solutions WD | last post by:
I have this query that I need to speed up. I don't know where to start. Any advise would be greatly apreciated SELECT centerID AS , StoreID AS , Region, City AS City, Owner AS , Brand AS Brand, (SELECT OrderDate FROM WHERE StoreID = S.StoreID AND revid = 0 AND programid = 4) AS , (SELECT count(*) FROM production WHERE P_S_RecID = S.StoreID AND P_PrintID like '%BrandSmart%' and P_PromoMonth = @Month and
9
1838
by: sara | last post by:
Hi - I have code (below) that ran as recently as Monday. We decided to change the location for the output reports, and now the code errors (13 Type Mismatch) on the query. The query runs fine on its own. The code still runs fine from the .mde. If I undo the change (single line) I STILL get the error. The .mdb compiles fine.
0
9688
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9544
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10490
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10259
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10030
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9077
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7570
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
4145
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3761
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.