473,320 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

List Box Queries

1
I am trying to link two tables together, JOB & REPAIR. A JOB can either be a MOT, REPAIR or SERVICE. All jobs are populated in the JOB table under the JOB TYPE row (MOT, REPAIR, SERVICE) is selected through a list box. I want the query to show JOBTYPEs (FROM JOB TABLE) to the matching tables of either MOT, REPAIR or SERVICE.

In lamest terms if the JOBTYPE in the JOB TABLE is an MOT, MOT TABLE should be updated with this JOB

HELP
Apr 4 '07 #1
1 1173
MMcCarthy
14,534 Expert Mod 8TB
I am trying to link two tables together, JOB & REPAIR. A JOB can either be a MOT, REPAIR or SERVICE. All jobs are populated in the JOB table under the JOB TYPE row (MOT, REPAIR, SERVICE) is selected through a list box. I want the query to show JOBTYPEs (FROM JOB TABLE) to the matching tables of either MOT, REPAIR or SERVICE.

In lamest terms if the JOBTYPE in the JOB TABLE is an MOT, MOT TABLE should be updated with this JOB

HELP
Have a look at this tutorial.

Normalisation and Table structures

Mary
Apr 4 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: rajdb2 | last post by:
Hi, the below list shows the top running queries in oracle on a database on a single day. Can we do something similar in DB2 v8 where we get a list of top 10 queries in execution time , or CPU...
2
by: Gabriel | last post by:
Hi, The following will generate a list of all tables and queries froma db: SELECT MSysObjects.Type, MSysObjects.Name, MSysObjects.DateCreate, MSysObjects.DateUpdate FROM MSysObjects WHERE...
4
by: Gerry Abbott | last post by:
Hi all, I've bound cbo field in a form, which draws from a list, with its 'limit to list' property set to true.When i add an entry to the form, from the list, I want to remove this item from the...
3
by: jallegue | last post by:
I am would like to get the list of queries that make a macro in MS-Access using vb 6.0.
3
by: Kevin Forbes | last post by:
So, I've found how to list all the tables in an Access database (as seen below) and running MS Access queries is easy (similar to executing a stored procedure), but how do I list the names of all...
1
by: Louly | last post by:
Hi everybody, In a form I have 2 combo boxes, X's Row Source Type is a "Filed list" and Y is based on a "Query". I wan to base X's drop down list on what's selected from Y's list. Can anyone...
5
by: jung_h_park | last post by:
From: jung_h_park@yahoo.com Newsgroups: microsoft.public.dotnet.framework.aspnet Subject: Dropdown List not retaining its SelectedValue Date: Mon, 26 Jun 2006 21:02:57 -0700 Hello, My...
3
by: iht | last post by:
Say I have a database with types of car driven by people living in different cities. I made several queries to separate out the database according to city, then made queries to count out numbers...
5
by: JvC | last post by:
Background Access 2003. MDB Front End. I am populating a list box with the names of queries in the system. I am searching for strings in the query names and then creating a value list for users...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.