Recent content by muriel

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.