Recent content by Saelin

I will try it out within the next 48 hours as of course, I have other responsibilities here at work. Again, I sincerely appreciate your time spent and patience. I already see how much easier this database will be to create. I'll keep you posted.

Definitely agree, and that's what I have been trying to work around with my limited knowledge. I was getting concerned about future data entries or converting all of this to a form eventually...which leads to: I don't expect you to tell me how to do this step by step but what area is this so...

Thanks for responding Gary, If I understand what you're saying correctly I actually haven't related 2 Autonumbers. This is the technique that Plog was talking about regarding breaking down the tables. The tables that have double primary keys are just Foreign Keys that are Long Integers. The...

Update: Initial Table Design & Relationships So attached is the updated relationships. Ignore the DaysOP_ID & HoursOP_ID since I haven't gotten to correcting that aspect yet of normalizing the database. To Recap, I am creating a Cardiologist Database with specific "Facilities", "Counties"...

I'll work on the DB in the next couple of days and will provide feedback. Thanks again.

I mentioned the autonumber for the sake of a primary key even though it's not needed for practical purposes. Forgive my n00bness, but it would be ok to not set a primary key for these new tables as long (as you said), that the each record is a unique combination of the ID numbers. And then...

Thanks for the replies, Gary & Plog. I see two different ways of doing the same thing, which is fine, but I'll have to choose...but I also want to make this a solid learning experience so I have some questions for each of you: So I could then with the subforms add as many services as is...

Hello Everyone, I am new to the forums and you can check my intro thread to read a little about me and my background in that introductory post (can't give you the hyperlink as I am under 10 posts :(). Anyway, I am creating a database (version 2007, if it matters) that will house: ·...

Hey Bob, Appreciate the welcome and well-wishes.

Hey Everyone, Real name is Stewart, but "Saelin" would be just fine. I live in Brooklyn, NY, and I'm 30 years old (I was born in England, btw). Anyway I stumbled on this site while researching Access and so I thought I'd join this motley crew. I am well versed in MS Office in general...