Multiple requests from one table.
in [Tables]
|
Prev: Linking tables
Next: network setup
From: Coffee Gal Coffee on 25 Jun 2008 18:01 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.
From: KARL DEWEY on 25 Jun 2008 18:15 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.
From: Coffee Gal on 25 Jun 2008 18:24 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.
From: KARL DEWEY on 25 Jun 2008 18:34 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.
From: Coffee Gal on 25 Jun 2008 18:51
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. |