Search results

That's a good idea but I remember over 20 years ago studying the one from Microsoft Access that had Chai tea in it. I was confused and burnt out then and a little bit now as well. :D But it's worth a revisit to a music db. Thanks

Here is where I get messed up. I really don't understand fully which fields are set to foreign keys and how to link them correctly. Image to show and to have you comment on if it is wrong or haw ro connect them properly. I know how to make the connections but I always get errors or just plain...

Oh yeah, I will find a way to learn how to make a relational database if it kills me! I will start with June7's instructions just to learn something and later on I may have the skills to better understand this stuff. :D

June7, Now that I understand that what I have already created is perfectly fine, I still want to try and learn some stuff about relational database design and here we have a good place to start. That RD was a typo (edited it). HEX would more than likely have the same or similar value but it's...

I see what you mean and I guess I should have listened but at least I know I already did the flat file db correct. Thanks.

Well that is a surprise. To think that I have stressed over trying to complicate what I had already done correct. Thanks for explaining that in more detail. I guess like I mentioned before I just need to learn how to pull the data I want using forms or queries and call it done. Now I feel like a...

I need that source :) I paid $45 for the whole Office Pro Suite. I will review your edited post. Thanks. I just read your edited post and that helps a lot to know I can do what I want and a couple of ways to accomplish it. I will go with the first suggestion to make it easier on my brain for...

Right. My question is what fields should I put into table 1 and table 2 for example? Or even table 3 if it makes any sense,

I think you know what I am trying to do. I was just trying to figure out exactly which fields would be in the first table and which ones would be in the second or even third table. Maybe I need to learn how to do the queries and forms too. With my simple database I didn't feel like I could...

This is just a personal database for my use only. No other people will ever access it. It will grow with many more filaments along with their related data for use in inventory and info that I would like to be able to search a little more accurately and to the point. Like if I want to see if I...

I have a lot of 3D printer filaments and I will be buying a lot more. I may have quantity of 6 white PLA filaments that are one brand or a bunch in other brands and types and same for a whole lot of other color and types. When I use a spool of a filament I can easily manually adjust the quantity...

The TD is the "transmission distance" which is not needed for everything I can do with a 3D printer and it takes some time to generate that info through various methods, The HEX is just the hexadecimal value for a color and is also only used here and there but can be useful sometimes. I was...

Hi everybody. I am currently using LibreOffice Base. I have ordered a new retail version of MS Office Pro 2010 so I will have ACCESS again when it arrives. I am somewhat a noob with databases but have some experience making flat file databases in the past and just recently again. I tried to...

Thanks for the welcome. :)

Thanks for the welcome. It's actually been pretty cold as I am in the panhandle. Freezing temps as low as 26 degrees at night. It was 32 degrees at 7:00 AM this morning. Better to be cold than whats happening on the west coast though.

Hi, I am still trying to figure out the most important part of relational database design. Now I am much older and I thought wiser but am still stumped when it come to making relationships between tables. I started with MS Access a long time ago and had some of those 700 page books and ended up...