Search results

Thank you! That did the trick!!

I believe my combo box is fine with 4, since my combo qry has 5 fields and I want the value that is in the 5th field. :confused:

Hi, I need some help trying to update a field in a form using the after update event of a combo: Me.TextboxName = Me.ComboName.Column(4) I'm using the field name of the textbox in my form as the control source for the field. The Combo is a qry to use in multiple fields as an autofill display...

Yes, I changed the FK on my tbl_PreNotes table to say Index but allow duplicates and then I was able to create the one to many. Thank you... :o) When you created the other relationships, did you create a new link table? (I'm not familiar with this yet.) Can you tell me how this works? Thank...

Does that mean the many side should not be indexed? Sorry, I'm a little confused. Does the relationship between the other tables have anything to do with it?

Can you tell me how to create the one to many relationship between tbl_DailyFiles (one side) and tbl_PreNotes (many side)? Thank you. NLR

Thank you for the info. I've updated my tables as you suggested, but no luck. tbl_DailyFiles can have more than one (many) tbl_PreNotes. But access sets this relationship up as a one to one. Also, I want tbl_Companys, tbl_AcctOwners and tbl_AccountInfo to have a one to one relationship and...

Hello, I'm working with Access 2010 and am trying to create a one to many relationship between two of my tables. Access will only give me a one to one relationship. The one side (tbl_DailyFiles) has a PK of DailyFileID and a FK of Pre-NoteID. The many side (tbl_PreNotes) has a PK of Pre-NoteID...

Yes, the query is the Source Object. Please see attached. Not sure if you need to see anything else. Thank you for your help! NLR

Hello, I am using a query as a subform and am getting the "Enter Parameter Value" window on several of my fields. The Parameter values its asking for are the Primary and Foreign keys. I've looked at my tables, and query and am not sure where I've gone wrong. Any suggestions where I should look...

Hi all, I'm fairly new working with Access and will need lots of help. :banghead:This site looks like it will be very helpful! Thanks to all in advance. NLR