Recent content by bcmarshall

I really like this approach. Can you explain how you did it?

I would like to apologize to everyone for my long radio silence. My mom has been in the hospital, and I haven't even looked at this since last Saturday. I appreciate your comment. In my own defense, I relied on the owner's 40 years of experience to guide me on his assessment that we won't...

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...