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 and a FK of DailyFileID. The FKs are formatted as Number (Long Integer) with the PKs formatted as Auto Number.
I don't see why I can't seem to get Access to give me the one to many relationship between these two tables.
Any help is appreciated! :banghead:
NLR
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 and a FK of DailyFileID. The FKs are formatted as Number (Long Integer) with the PKs formatted as Auto Number.
I don't see why I can't seem to get Access to give me the one to many relationship between these two tables.
Any help is appreciated! :banghead:
NLR