Multiple requests from one table.

[Coffee Gal]

I have fairly complicated database set up for construction management. I am
having a problem with one new report that I need to generate. One of my
tables is "Customers". From this table I need to fill in each of the
following sections for the Owner, General Contractor & Customer Rep.:

Name, Address, City, State, Zip, Contact, Phone, Fax, Cell

When I link the text box for each, information in the other boxes change to
whichever item I am focused on at the time. I do not want to separate my
Customers table into 3 separate tables because many times 2 or all 3 of the
sections will contain the same customer information.

I have been working on this for several days and it is probably just a
simple issue that I cannot think of right now.

 

[KARL DEWEY]

Do not quite follow - is there a single record per customer or three records,
one for Owner, General Contractor, and Customer Rep?

In other words is your table like this --
Customer
Owner
General Contractor
Customer Rep
Name
Address
City
State
Zip
Contact
Phone
Fax
Cell

Or like this --
Customer -
Type - Owner, General Contractor, or Customer Rep
Name -
Address
City
State
Zip
Contact
Phone
Fax
Cell

 

[Coffee Gal]

There is one table that has the following fields:

Customer
Name
Address
City
State
Zip
Contact
Phone
Fax
Cell

I have one report that I need to generate with Owner information, General
Contractor Information and Customer Rep information. All the information
needs to be drawn from the same table.

 

[KARL DEWEY]

Is there a single record per customer or three records?

Which field tells you whether they are Owner, General Contractor, or
Customer Rep?

 

[Evan Keel]

I have fairly complicated database set up for construction management. I am
having a problem with one new report that I need to generate. One of my
tables is "Customers". From this table I need to fill in each of the
following sections for the Owner, General Contractor & Customer Rep.:

Name, Address, City, State, Zip, Contact, Phone, Fax, Cell

When I link the text box for each, information in the other boxes change to
whichever item I am focused on at the time. I do not want to separate my
Customers table into 3 separate tables because many times 2 or all 3 of the
sections will contain the same customer information.

I have been working on this for several days and it is probably just a
simple issue that I cannot think of right now.

If you would post your DDL and a "sketch" of your desired report you would
make life simpler for all of us.

Thanks,

Evan

 

[Coffee Gal]

There is 1 table. One record per customer. There is no field to designate
which title the customer holds because they may be all of the 3. If we are
working for the VA, they have their own contracting so they are the Owner,
General Contractor and Customer Rep. When we work for the School System they
have a separate GC but they are the Owner. Either the GC or the Owner can
act as the customer rep. that is why I don't want to duplicate the table.

 

[KARL DEWEY]

Ok. I do not see a way to do what you want with your present table structure.
One method would use the structure I posted --
Customer
Owner
General Contractor
Customer Rep
Name
Address
City
State
Zip
Contact
Phone
Fax
Cell

Then you would have seperate fields.

 

[Coffee Gal]

This is how the report needs to look:

Customer's Representative Information:
Name:_________
Address:_______
City,State,Zip:_______
Contact Name:_______
Phone:______
Fax:________
Cell:_______

Owner Information:
Name:_________
Address:_______
City,State,Zip:_______
Contact Name:_______
Phone:______
Fax:________
Cell:_______

General Contractor Information:
Name:_________
Address:_______
City,State,Zip:_______
Contact Name:_______
Phone:______
Fax:________
Cell:_______

There is one table with the fields:
Name, Address, City,State,Zip, Contact Name, Phone,Fax,Cell

I don't know what you are referring to as "DDL".

 

[Coffee Gal]

OK, so I would then use the addidional fields as a true/false toggle & query
on those fields to select for each item on the report. I feel like such an
idiot right now. I have done 10 tables, 16 reports & 12 forms in the last 2
days and I just couldn't figure this one out. My brain was in overload. I
knew it had to be something really simple that I just couldn't see past what
I was working with.

THANK YOU SO MUCH!

 

[Evan Keel]

This is how the report needs to look:

Customer's Representative Information:
Name:_________
Address:_______
City,State,Zip:_______
Contact Name:_______
Phone:______
Fax:________
Cell:_______

Owner Information:
Name:_________
Address:_______
City,State,Zip:_______
Contact Name:_______
Phone:______
Fax:________
Cell:_______

General Contractor Information:
Name:_________
Address:_______
City,State,Zip:_______
Contact Name:_______
Phone:______
Fax:________
Cell:_______

There is one table with the fields:
Name, Address, City,State,Zip, Contact Name, Phone,Fax,Cell

I don't know what you are referring to as "DDL".

Sorry about "DDL". I thought this was the MySQL group.