Alhakeem1977
Registered User.
- Local time
- Tomorrow, 00:20
- Joined
- Jun 24, 2017
- Messages
- 308
How can I join tables as below:?
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
tblFacilityRegister
""""""""""""""""""""""""""
ID (PK)
SenderID (FK)
ReceiverID (PK)
ScannedBy (FK)
,,,,,,,,,,,,,,,,,,,,
tblUsers
""""""""""""
UserID (PK)
FirstName
LastName
EmailID
I want to join UserID (PK) from tblUsers to all (FK)'s from tblFacilityRegister, how can I do that? I did it in the relationship window by duplicating the tblUsers twice, it works fine but when I want to place the SenderID, ReceiverID and ScannedBy Firstnames and LastNames in a query I got an empty values.
Is the there any way solve this issue?
Do I have restructure the tables?
Your earliest response is highly appreciated.
Thanks in advance
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
tblFacilityRegister
""""""""""""""""""""""""""
ID (PK)
SenderID (FK)
ReceiverID (PK)
ScannedBy (FK)
,,,,,,,,,,,,,,,,,,,,
tblUsers
""""""""""""
UserID (PK)
FirstName
LastName
EmailID
I want to join UserID (PK) from tblUsers to all (FK)'s from tblFacilityRegister, how can I do that? I did it in the relationship window by duplicating the tblUsers twice, it works fine but when I want to place the SenderID, ReceiverID and ScannedBy Firstnames and LastNames in a query I got an empty values.
Is the there any way solve this issue?
Do I have restructure the tables?
Your earliest response is highly appreciated.
Thanks in advance
Last edited: