lacampeona
Registered User.
- Local time
- Today, 14:54
- Joined
- Dec 28, 2015
- Messages
- 392
Hello
In attachments please see my 3 tables.
Can somebody look and tell me why I cant create a relationship beetween them? What I am doing wrong? the most important thing is the field SerijskaStevilka ( serial numner of the colon)
1. tblKolone ( table Colons)
2. audKolone ( audit table for table Colons)
3. tblPrevzemKolon ( table borrow Colons)
4. audPrevzemKolon ( audit table for borrowing Colons)
5. tblVraciloKolon ( table of returned colons)
6. audVraciloKolon ( audit table for returned the colons)
how it works?
Imagine you are user and you want to use colon with serial number 006A. you take the colon 006A on 24 the february and on the 26 of the february you are returning back the colon. you have to return the colon so next time another user can take the same colon.
i want to create query that will tell me...who on which day take the colon with serial number xxx and when and who returned back the colon with the serial number xxx.
note: only user who take the colon with xxx can return the same colon back,
I create separate and is working...but i want to make one large query that will tell me all?
how would you create the tables? what you reccomend me?
thank in advance
Elena
In attachments please see my 3 tables.
Can somebody look and tell me why I cant create a relationship beetween them? What I am doing wrong? the most important thing is the field SerijskaStevilka ( serial numner of the colon)
1. tblKolone ( table Colons)
2. audKolone ( audit table for table Colons)
3. tblPrevzemKolon ( table borrow Colons)
4. audPrevzemKolon ( audit table for borrowing Colons)
5. tblVraciloKolon ( table of returned colons)
6. audVraciloKolon ( audit table for returned the colons)
how it works?
Imagine you are user and you want to use colon with serial number 006A. you take the colon 006A on 24 the february and on the 26 of the february you are returning back the colon. you have to return the colon so next time another user can take the same colon.
i want to create query that will tell me...who on which day take the colon with serial number xxx and when and who returned back the colon with the serial number xxx.
note: only user who take the colon with xxx can return the same colon back,
I create separate and is working...but i want to make one large query that will tell me all?
how would you create the tables? what you reccomend me?
thank in advance
Elena