Search results for query: *

Thanks for the help guys! I currently have 5 tables, each one has an ID as the first field, which is also the primary key. As for the relationships, I have the primary key of the first table related (one-to-one) to the primary key of the second. Then the primary key of the second related to...

Hey guys...any help would be great...I'm stuck... I just created a very basic TABLE with two fields: Name and Address. Then I created a basic FORM to enter the data into the table. It works fine. If you close everything out, and then open up the FORM again, it starts with the information...

Thanks PHV, that was pretty good. I think I'm having a problem with defining the relationships. If table A has a primary key, and table B has a primary key, do I just put the relationship between those two keys? Or should the relationship go from the primary key of A to a field in B?

Hi folks, any ideas would be great.... Say I have 3 tables, A, B, and C. I'm trying to create a form that will allow me to enter information into those 3 tables using 1 form. I'm having problems. Is there any kind of relationship that I have to define between the 3 tables to get this to work...

Cool, thanks ZOR. So the switchboard can be used to point to certain forms or reports? And maybe I can throw a picture on the switchboard to make it look more official? Or can this be done with a form, too?

TheAceMan1....thanks for the idea, I've never used the switchboard before. I always thought those menus were just forms or something. Do you know how to get the switchboard to open up first when you open the db? missinglinq, the only reason I'm doing it this way is because it calls for...

Hi folks...any help would be great... Say I have a movie database, with a bunch of forms. One form lets you add movies, another lets you delete movies, another lets you update movies, and so on. How can I create a "menu" so that when the database is first opened, the user is given a few...

Thanks guys, that was a great help! The first one from dhookom I got to work, but the one from steven290 keeps giving me an error that says "At most one record can be returned at this subquery". Anywho, for the first one that I got to work, I don't quite understand why that works. Does it...

Hi everyone, great site. I've been looking around for a while, and now this is my first post. I'm having a SQL problem...any help would be great. I have a table (SCHEDULE_t) that contains teachers and the classes they teach. See below: TEACHER CLASS 0001 MATH 0001...