Search Result

I have three tables that I want to pull information from. All three tables have a job number field which i would use as the main connection between them all. What's the easiest way to join these three tables without having duplicate data in the report?

Hi Everyone,

This thread originated from another topic previously posted.

Whilst designing a database I have encountered a significant issue in being able to generate queries that combine data from multiple related tables (e.g. generating a query that combined information from the Staff, Positions and Allocations tables to allow me to view a Staff name, Allocated position number, and Position description [using the common...

I have four tables in access 2003: T1 (8 fields), t2 (5 fields), t3 (7 fields), t4 (3 fields) all connected to each other with t1.a = t2.a, t1.a=t3.a, t1.a=t4.a (T2, T3 and T4 contains the FK for T1.
My program has a listbox with t1.a populated on it. When the user clicks on an "a value," it would search the database and populate the textboxes which are supposedly connected to the fields (distributed to the 4 tables).
My...

Hey all,

I need to join 2 tables like the following scenario below, can anyone enlighten me as to what type of join this would be (or better yet an example of how the query would be set up)?
.....

Example -

Student Table A has 5 columns (firstname, lastname, gender, section_A_id, section_B_id)

Student Table B has 2 columns (id, sectionname)

I want this returned in 1...

Hello, I'm hoping someone could help me out with a problem I've ran into while trying to create a training database. I'm just a beginner with Access and VBA so please take that into consideration.

The problem I'm having is the possibility of record duplication in my current database. I'm hoping maybe there's a way to set up a relationship or query/vba to prevent this.

I currently have a form (frmCE_AddAgent Training)...

Table1

Bill
billno
P001
P002


Table2
Patient
Patno service amount
P001 s1 100
P002 zz 200
P001 s2 400


.......

Hi everyone,
This is my question/problem.

I have a table with orders and a table with order details.
Clients can order multiple products at once during one order, so one line has to be inserted in the main order table, and multiple order details from the same order in the order detail table.

How do I do this?

Right now if a client orders 5 products during one order, the order detail table...

Hi

I am trying to tidy up an access database that has traditionally just been used as a spreadsheet. I have split up the information into different tables and need some help transferring information.

I now have two tables:

Client Info - Client ID (primary key), Name, DOB,
Client Address - Address Id (primary key), Client ID, Address 1, Address 2, etc

They are linked (client info)...

Hello,
I have two tables
1. Person
2. Doctor

DoctorId is in Person table as forfeign key.

I have created a form based on Query.
I am displaying person information (name, address, phone,..) along with its doctor info (Name, Address, tel). Name is in combo box which contains all doctors which are in doctor table.

For display its working fine but when try to change the doctor...

I have been asked to create a "google" style search functon for my SQL server 2000 db using and access 2003 (.adp) front end form. I would like to be able to enter something into a text box and have all the records from different tables (where that string occurs in the record) shown in a popup form, from which the user can select one of the records to go to (i.e. they will double click on the record and it will open the proper form for...