Search results

So what you are saying here WIS is that when I include a subform for my Sessions table its Speaker ID field will automatically be filled in when I input the data to the main Speakers form? And this ocurrs because of the relationship that I have established between the two tables. Have I got this...

Thanks a lot for your help today WIS, it's been very useful in getting my DB working right. I'll be working night shift tonight so I'll have some time to read up on forms and subforms so I can add the subforms to my DB. Thanks Formula1

Thanks WIS I appreciate the help here. However, I have a question. In the Sessions table you have put numberic values in the Speaker ID field. That's all well and good, but where exactly did you get these numbers? Did you input them manually? Or are they placed in that field automatically...

Thanks Ok, what is the best basic book that you know of to get for a beginner WIS? Formula1

Ok WIS, I have manually put values into the Speaker ID field in the Sessions table and my queries work perfectly now. Thanks for the suggestion. However, there must be a simpler way for me to somehow place values automatically from the first table into the second table so I don't have to do it...

Thanks for the replly WIS. However, the Speaker ID in the Sessions was just a field that I put there so that I could join the Speaker ID from the Speakers table to the Sessions table. Do I actually have to manually input the Speaker ID values in to that field to make this workable. That seems...

Also, when it comes to the "Join Type" that is selected for this relationship and query it says in the "Join Properties" box: "Only include rows where the joined fields from both tables are equal" Now I have experimented with the other two join settings and the query output will include the...

Hi there everyone, I have been trying to complete an assignment for a computer course and I have run into a real stumbling block in respect to getting data from my two tables to display in a query. Here's the essentials of my problem: I am using Access 2007 for this assignment and I have...

Also, when it comes to the "Join Type" that is selected for this relationship and query it says in the "Join Properties" box: "Only include rows where the joined fields from both tables are equal" Now I have experimented with the other two join settings and the query output will include the...

Has anyone ever had this problem in one of their database queries?

Ok, I have two tables: Speakers and Sessions. Speakers Table: Primary Key:Speaker ID(This is joined to the Speaker ID field in the Sessions table) Data Type: Autonumber Field Size: Long Integer Indexed: Yes(No Duplicates) Sessions Table: Primary Key: ID Data Type: Autonumber Field...

Hi there everyone, I have been trying to complete an assignment for a computer course and I have run into a real stumbling block in respect to getting data from my two tables to display in a query. Here's the essentials of my problem: I am using Access 2007 for this assignment and I have...