Search results

ALL - Thanks for all the guidance. As I stated initially... I'm a relative newbie just trying to learn. I worked with a package called SMART about 3 decades ago. From what I remember it was relatively easy to work with forms and fields so I thought this would have a simple answer. I also had a...

I really wouldn't need to add fields. Currently there are 12 competitors in the table but at least 2 of them are Out of Business and their info could be replaced without adding additional fields and screwing up the queries. I understand now about the normalized.

Ahh but I actually would have each Regal item repeated 12 times, not 3 times. so my small table becomes a 75,000 line behemoth... ;-)

Hi Larry, This isn't the actual DB but this is what I am looking at. I have the top row of related tables. I simply want to enter via a form, a Manuf EDP have it return the Regal EDP which then links to other tables so the resultant data is viewable but not changeable. (Bottom table for the...

Larry, Multiple companies (including yours) (Currently in fields) Which manufacture multiple products (currently in records) Each product has an EDP number, part style, (for each manufacturer) This is all the data in my current table. You are on the right track but the initial reference of...

OK. Let me try to explain this. I have a table (Data compiled from Excel throughout many years in my industry. This table is a basic cross reference matrix for my current company and other competitors. So the data is as such, note that the description is for the example. Only the actual part...

Pat, This is simply one piece of a larger project that I am working on. EDP # is a unique (to each manufacturer) item code for a specific technical product that we (and others) manufacture. I believe EDP was originally "Electronic Data Processing #". There are variations of each item based...

Hi Pat, Table was already built originally as an Excel spreadsheet and imported. It actually lists Brand A EDP, Brand A List #, Brand B EDP, Brand B List #.... Currently there are 12 competitive companies in the table. Not sure what you mean by normalized. The data is clean. I simply want to...

I am a relatively newbie to Access. Familiar with relational databases and did some DB programming 20-25 years ago... but can't remember certain things... I have a pretty basic project I am trying to create. Basically want to create a form to cross reference competitive EDP numbers with my...

I used Access maybe 20 years ago... Can't remember much from back then. Relatively competent with WIndows/Office etc. but now have a need to catch up specifically with Access. Used to skydive and fly but now into boating...