If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple requests from one table.
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. |
#2
|
|||
|
|||
Multiple requests from one table.
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 -- KARL DEWEY Build a little - Test a little "Coffee Gal" wrote: 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. |
#3
|
|||
|
|||
Multiple requests from one table.
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. |
#4
|
|||
|
|||
Multiple requests from one table.
Is there a single record per customer or three records?
Which field tells you whether they are Owner, General Contractor, or Customer Rep? -- KARL DEWEY Build a little - Test a little "Coffee Gal" wrote: 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. |
#5
|
|||
|
|||
Multiple requests from one table.
|
#6
|
|||
|
|||
Multiple requests from one table.
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. |
#7
|
|||
|
|||
Multiple requests from one table.
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. -- KARL DEWEY Build a little - Test a little "Coffee Gal" wrote: 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. |
#8
|
|||
|
|||
Multiple requests from one table.
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". |
#9
|
|||
|
|||
Multiple requests from one table.
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! "KARL DEWEY" wrote: 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. -- KARL DEWEY Build a little - Test a little "Coffee Gal" wrote: 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. |
#10
|
|||
|
|||
Multiple requests from one table.
"Coffee Gal" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|