Search results for query: *

Thanks for your help - much appreciated.

Ken S. - thanks for the response. That's what I thought. I'll check out the threads you posted.

HomeAlone, Thanks - that helps a lot!!! Another star for you. Followup: I need to set the Limit to List property to No, because users will need to type in items that are not in the combo box list. When I set it to No, I get the error message "The first visible column, which is...

Thanks - that does help. I really appreciate your advice. So would I also need to have the four separate fields in my join tables. Eg: AuthorID1, AuthorID2, AuthorID3, AuthorID4, OrganizationID1, OrganizationID2, OrganizationID3, OrganizationID4?

Correction to my most recent post: Here's where I'm seeing the problem: I have the articles table set up as the main form. It contains name of article title, etc. Then I have the author table, with the organization subform. The users will enter the data on the articles form first, then open...

Maybe I'm making this more difficult than it is - believe me, that would be a relief. The 3 tables I listed above are just part of the table design. I also have an articles table, publication table and keywords table. Authors and publication tables are many to many; publication and...

I'm designing data entry forms and have a few many to many relationships that I've broken down into one to many relationships with join tables. The type of data entered will be bibliographic data. Example of tables (to name a few) Author_tbl AuthorID (primary key) AuthorName...

Thanks for the responses - much appreciated.

I'm trying to create a combo box on a subform. I have a many to many relationship between two tables. I'm creating the main form with one of the tables, and the subform with the join table. Now when I'm creating the combo box, I need to have the ID stored in the join table. Problem is, if I...

I'm trying to decide which would be better to do - base the forms off of queries or the tables themselves. I have a few many to many relationships, with join tables to make them one to many relationships. To clarify my earlier question, I'll use an example from my database. I have...

Thanks - that makes sense to me. Followup question - how do I insure that the entries being made on separate forms (sending the data to separate, normalized tables) are being stored as one record? In other words, when I want to query or search a record, how does Access keep the entries as...

I'm sure this is very obvious to most of you. I have a database which will start out as purely data entry - there will not be any data to start with. I want to enforce referential integrity, but in the testing process, the users are trying to enter data, and they keep getting error messages...

Thanks again. I know it'll eventually work out - I have to just keep at it. Stars for Kevin & Richard.

Thanks for all your help - I'll give it a go.

That helps a lot!! Thank you. One followup - do you see any way I can have all of these fields on one form? I've been instructed to make the data entry process as fast and as simple as possible. Thanks again.

There's nothing in the AuthorOrganization_tbl except 0s. How do I make sure the IDs are being stored in the AuthorOrganization_tbl? In other words, when data goes into the Author and Org tables, respectively, record by record, how do the IDs get stored in the intermediate table? Thanks again...

First, I really appreciate all your help and patience, especially Richard, who has gone above and beyond the call of duty in helping me. 1) I've determined that the relationship between Authors and Organizations is many to many. 2) I took the OrganizationID out of the Author_tbl. 3) I ran the...

I've searched the forum regarding why a query wouldn't return data. So far, I have not been able to solve my problem. I know there's probably an easy solution that I'm overlooking. The problem is when I'm querying tables that have many-to-many relationships, where I've created join tables...

...data in them. I'm obviously doing something wrong, but I don't know what specifically. Query: (for Authors and all Orgs associated with them) SELECT Author_tbl.*, AuthorOrganization_tbl.* FROM Author_tbl INNER JOIN AuthorOrganization_tbl ON Author_tbl.AuthorID = AuthorOrganization_tbl.AuthorID;

Richard and Leslie - thanks for all of your continuing help!! I've been out for a few days, and now returning to work on the database again. I will try your suggestions and post any more questions. Thanks again!!