Questions tagged [linktable]
23 questions
0
votes
1 answer
Selecting View Item returns Null (Checklist Link Table)
I seem to be having a problem with a query showing a specific item if it is in the checklist table. I currently have multiple tables which the main are user, character, series, item & checklist. Character & Series are linked into the item table,…
Jake
- 141
- 3
- 12
0
votes
0 answers
Does a link table always needs his own identifier?
I am making a database for a school project and I am stuck at a certain point. I am wondering if a link table always needs his own identifier or are the PK's from the two other tables good enough?
The reason why I ask this is that I cannot find a…
Maxime de Lange
- 287
- 2
- 7
- 21
0
votes
1 answer
Get present primary keys from link table, set Checkstate checklistbox
I have a CheckedListbox which contains values from some table called products.
The idea is to check the products that are associated to a customer. Now it does save correctly in an link table, yet when loading it again, the items that were checked…
CularBytes
- 9,924
- 8
- 76
- 101
0
votes
1 answer
What about link tables in domain-driven-design?
In the book .NET Domain-Driven Design with C# from Tim McCarthy there's an example of a link table (two foreign keys + one boolean column) that gets it's own class in the domain. Is this common?
The example is a Contact table and a Project table.…
Lieven Cardoen
- 25,140
- 52
- 153
- 244
0
votes
1 answer
Foreign Key Input error in Link table (Error 1005)
I was trying to input my foreign keys into my Link table all at once.
I created all my other tables first then my link table, i added columns to my link table for the foreign keys (that worked). Then i went to insert my foreign keys and it doesn't…
David yaq
- 3
- 1
0
votes
1 answer
MySQL as a bridge for SQL Server 2008 in Linux (Ubuntu)
In Windows, there is a link table feature in SQL Server (or MS Access). Basically, if I link SQL-Server and MySQL, then when my apps write something in SQL-Server, the MySQL is also updated via ODBC connection.
Basically the flow is: win-apps ->…
Bonn
- 53
- 1
- 13
-1
votes
1 answer
Left joining Mysql with link table and ORDER and LIMIT
I am developing a chat feature that has the tables cases, entries and attachments. Each chat (case) has chat entries that has one or more attachments. The attachments can be for example a text message or a video message. Now I am struggling to…
willstedt
- 43
- 5
-1
votes
1 answer
How to select names using link table?
So I have a check to see if you're allowed to view that folder(currently checking if the ip is my home ip)
I want this check updated into checking if your account has the rights. So i want to get all the names from gallery_folders where user_id =…
ShittyAdvice
- 265
- 7
- 18