Search results

I'm located in Southern California...in the greater Los Angeles area. I'm in the Computer Science department of one of the state universities. I didn't ask around too much, but I got the impression there weren't many (any?) faculty members in my department who were particularly strong in...

Simon, Thank you, too, for your participation in this discussion. I agree with much of what you said. If you review my comments to Pat, you'll understand why it was set up as poorly as it was. I have since corrected everything, using Pat's revised database as a starting point. If nothing...

Thanks for your comments. I put it together very quickly, in front of the class, and wanted to emphasize some other issues which it did. But I would never use the type of structure in a real life situation. It was generous of you to modify it in a much better fashion without beating me up too...

One more point. If you look at the snap-shot of the relationships, you'll note that the IDs in both the COLOR and MAKE tables are not their primary keys. I just left these fields there to illustrate autonumbering. My relationships are between primary keys and corresponding fields in the...

Pat, this is getting out of hand. I deliberately used different names in the fields to demonstrate that they don't have to be the same in two tables, BUT I emphasized to the students I was addressing that having them the same helps understand the relationships...just as you correctly stated...

Yes, in a real world situation, it's possible for one owner to own multiple vehicles. This was supposed to be a simple example to demonstrate some of the features of Access to students. In a real situation, I would probably use multiple join tables and other techniques; somewhat as would be...

You misread me. I said I'm very familiar with many, many programs but not very familiar with Access. I know what a Wizard is, but I wasn't sure which one you were referring to in your comments. Having said this, I do appreciate your assistance. I was putting together a simple example for...

Simon, If you look at my attached simple database, you'll note that before someone enters owners, they have already entered a number of vehicles. By the time the owner's form is opened, specific combinations of make/color have already been associated with various VehicleIDs. So, when entering...

Pat, perhaps this will help. Consider two tables: Vehicle VehicleID Make Color Owner OwnerName CarOwned Make Color A one-to-many relationship will eventually exist between the Vehicle.VehicleID and the Owner.CarOwned fields. I want a form which permits me...

Pat...I'm a professor of computer science so I'm reasonably familiar with all the concepts, but I must admit that I'm not totally sure I followed what you've suggested. For example, I'm not sure which wizards I should use and how I get them to do what you suggested. Perhaps I should just send...

Join the club. I, too, am quite unfamiliar with Access and have virtually the same question. I want to create a simple form which displays a combo box. The combo box displays three fields for a number of records in the table.When a user selects one of the choices (e.g. record ID) being...