Search results

I really appreciate your comments, and those of everyone else. I'm working on the transition.

How would I create three default fields when the subform is opened?

/****** Object: Table [dbo].[CVInsQuotes] Script Date: 6/25/2025 3:43:48 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CVInsQuotes]( [IQID] [int] IDENTITY(1,1) NOT NULL, [CVID] [int] NOT NULL, [Company] [nvarchar](25) NULL,

I've already acknowledged the error of my ways and I'm working on changing it to a normalized configuration. One question though. Can I open the subform with the first three datasheet company names defaulting to the three named fields I currently have?

Table definitions: CVSource - Holds data on Dealers/Sources, one to many relationship on PK SourceID to CV referrals. It holds company name, contact name, contact info, etc. All text fields are nvarchar of various lengths. CVReferrals has PK CVID, and holds individual customer information...

Wow! So much work and effort to help me. Thank you seems a bit shallow. I'm gonna make the changes you've suggested. I can't tell you all how much I really do appreciate the things you've done for me.

Although it may appear that way, I assure you that your collective comments have not fallen on deaf ears. I've been listening carefully. These conversations have made me realize that right now my development is technically a hybrid. I have quasi-normalized data in the three generic fields...

I know you're absolutely sincere in your warning, and I do appreciate that, but please consider the following. Worst case nightmare scenario is that after we have 10k or 50k records in the system, one of the three major companies named in the fields goes out of business, or, more likely...

I drank. I also tasted the water from other wells. Please don't confuse a conscious, thought-out decision (even if it's one you would not recommend), with obstinacy. They are in no way the same thing.

You have my permission to use the quote, not that you needed it. But thanks for asking. I did not come to this forum, hat in hand, seeking help from a bunch of caring strangers with common interests, with the intention of just ignoring what was so sincerely offered. You guys are superstars...

I'd like to include a screenshot of my main data entry form. I hope it helps others to understand why I made the choices I did. By the way, this is a database within a database. The company has been up and running for 15+ years, and this part of the development is to accommodate a new...

Thank you for understanding. I am doing exactly that, working with "what is possible". My goal, and the company goal, is to have something that works the best for them. I think I've chosen correctly. Time will tell, and I'm the kind of guy that will return to this thread in three years and...

Actually, data analysis is a very big piece of our company's legacy. The way I've got it structured we will be able to analyze sales, company quotes, trends, and everything else needed. I've been developing this DB for 15 years, and because of the reports available, the owner knows more...

GPGeorge wrote: Unfortunately, there's no way to show you ahead of time what the consequences are going to be. As I posted earlier, it's a matter of the number of future billable hours of work that will be required when Safeco goes out of business and you have to add a new field for the...

I know you did. Sorry I didn't give you credit for it. It was very helpful.

Again, I truly appreciate everyone's input and efforts. This is what I've decided to do. First, there's no doubt that those that recommended normalizing the database and using a separate table are telling me the "right" way to approach this. I use quotation marks, because even though I...

Plog, the table I created is exactly as you suggested, with only 4 fields. ID, CVID (ID field on table containing the customer data), Company, Quote. I can link the tables in a query by CVID, but I now have only one field for company name and one field for quote amount that I can use on the...

I'm struggling with this. I have created the second table exactly as plog suggested, Where I'm having the issue is in integration of that table into the source query for the form, and with the form fields themselves. In my current form/table configuration, it's quite easy to create a control...

Thank you all for your help. I'll restructure the tables. I really appreciate all the input.

I have a database for an insurance company, and I'm trying to find the minimum value among 5 or more fields. I have fields named for each of several companies. Imagine Progressive, National General, Geico, Safeco, Liberty Mutual. Each field is currency, and will contain the quote received...