Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by carudy

  1. carudy

    Return a field from a table that depends on data of current

    Thank you for your help. I am working with the client to determine the impact on their existing system if we normalize the table. I agree that the view would work, but it would be too difficult to manage. There are more than 30 of these SqFt Types fields. Thanks again.
  2. carudy

    Return a field from a table that depends on data of current

    Terry: One other note, the database was setup with the Sqft fields in the tblPlan table. Due to the complexity in returning this data, I am working to get the data moved to a new table. This table would have the following fields: PlanId, SfType, SqFt. This would allow me to perform the...
  3. carudy

    Return a field from a table that depends on data of current

    Terry: Here is the actual tables and some of the business issues. This issue is in the Home Builder Industry. These are single family homes. The first table is a Plan table which includes fields for a floor plan that they offer. tblPlan PlanId # Rooms Stories CarpetSF EntrySF...
  4. carudy

    Return a field from a table that depends on data of current

    Terry: I am needing to return a diffent column for each row. The column name is the data value. I would need to return: Id SF ------- -------- 1 500 - lookup Id 1 and SFTYPE = Carpet 2 550 - lookup Id 2 and SFTYPE = Allfloor For Id 3, I would lookup...
  5. carudy

    Return a field from a table that depends on data of current

    Terry: Thanks for the repsonse. That would work, but I left out one key piece of information or I am not clear of your response. I want to return the results as a resultset. The results I want are a recordset that looks like this: ID SF 1 500 2 550 Can I do that lookup on a row by...
  6. carudy

    Return a field from a table that depends on data of current

    Is there a way to return the value from another table that is the field name of the value of the current table. EXAMPLE - Table 1: ID SFTYPE 1 CARPET 2 ALLFLOOR 3 WOOD Table 2: ID CARPET ALLFLOOR WOOD 1 500 750 125 2 350 550 75 If I...
See more

Part and Inventory Search

Back
Top