Stack Overflow
Stack Overflow

Questions tagged [table-relationships]

220 questions
0
votes
1 answer

Bulk insert in rails

I cannot solve the following problem Any help or suggestion is appreciated Agent collects orders for Product on a paper going from one Shop to another in his Region. At the end of the day, he inserts the quantity of each Product to each Shop. Each…
nturganaliev
  • 45
  • 7
0
votes
2 answers

MS Access subform not displaying records and not navigating

I have a one-to-one relationship between an SLD table and an ORDER table. The SLD table is the main form, ORDER table is the subform. The main form's table has more records than the subform table. Master and child links are set. I have decompiled…
Marcus Mackaku
  • 27
  • 11
0
votes
1 answer

Subform does not display in Form view

I have a subform that is derived from a query consisting of a calculated field. It does not display in form view. I have set the Master and child field links and my 'Allow Additions' property is set to yes. What I have discovered is one of the…
Marcus Mackaku
  • 27
  • 11
0
votes
1 answer

CakePHP model associations via an intermediary table?

I have a Home model that links to a Realtor model on Home.realtor_num = Realtor.num. I have an Office model linked to the Realtor model on Realtor.office_num = Office.num. Suppose I want easy access to Office.name in the result set of a find on the…
thesunneversets
  • 2,560
  • 3
  • 28
  • 46
0
votes
2 answers

Laravel maatwebsite import and fill a column with a select form

I'm using maatwebsite's Excel import library to import employees into a database table and it works quite well. However, on the View page where I select the Excel file to import, I have a select drop-down that shows data from the related Companies…
PDevH
  • 63
  • 1
  • 10
0
votes
2 answers

SQL How to group a column for a given range and join to other table for counting related rows with the first column

I need to group users column according to given year ranges. This is example year ranges (1980-1989,1990-1999,2000-2009) And then, I need to join to count results from another table. I created a database "user_relations" and I have created two…
Oğuz Can Sertel
  • 749
  • 2
  • 11
  • 26
0
votes
2 answers

Ms Access, using Excel to modify tables; dealing with ID autonumber

TLDR: I summarized the long question at the end of the question. My business is using an Ms Access DB properly set with relationships, PKs, and FKs. I sometimes have to make major modifications to tables (adding fields, conducting column operations,…
Vincent Labrecque
  • 304
  • 1
  • 5
  • 12
0
votes
2 answers

Access Database - Two foreign keys in same table related to same primary key

This is in relation to an Access Database. I have a first table that lists employees with a primary key of id. In the first table, I include all employees (whether overlords or underlings). I have a second table that identifies approvals of…
blainedwards8
  • 57
  • 1
  • 7
0
votes
1 answer

How to efficiently determine if two tables are related?

I've many pairs of tables and I want to efficiently determine which pairs have tables that are related to each other by PK-FK relationships. If PK-FK relationship is documented, I'll leverage that but I cannot assume that it's always documented.…
user1590695
  • 23
  • 5
0
votes
1 answer

Relationship hasone trying to get property of non-object

I got a problem with relationship one to one mechanism for edit & update condition, so I have model Siswa and Telepon, with Telepon belongs to Siswa... here is the code Siswa.php (model) class Siswa extends Model { protected $table =…
Rayan Suryadikara
  • 237
  • 1
  • 3
  • 17
0
votes
0 answers

Linking two databases with code first framework

Using code first framework in mvc, I have created a database of artists, but I want to now create a database of artwork for these individual artists. Something like this: Artist Id=1 -> Artwork Id=1,2,3,4 , Artist Id=2 -> Artwork Id=1,2,3,4 etc How…
Wiliam Cardoso
  • 434
  • 1
  • 8
  • 23
0
votes
0 answers

MYSQL multiple join on same table with control field

I have the following table structure: The registration table, indicates the type of client's contract, if is checked (1) it means that the client is directly related to the class table, if not (0), it means that the client is related to a group and…
wiLLiamcastrO
  • 238
  • 3
  • 13
0
votes
1 answer

Filemaker Database design for Film project

I have been asked to create a database to track the frames in a short industrial video. I have 10,000 frames which are each referenced in a container field in Table "Thumbnails" with an associated frame number (a positive 6-digit integer). I have…
JThomson
  • 5
  • 6
0
votes
3 answers

Many to Many Relationship

Please help me understand further the many to many relationship. Suppose I have Teacher and Students Table and in my understanding it is one-to- many. Teacher TeacherId Primary Key TeacherName Student StudentId Primary Key TeacherId Foreign…
heisenberg
  • 1,784
  • 4
  • 33
  • 62
0
votes
2 answers

Rails "has_one" relation. Assign Project to Customer(Timestamp)

I'm building a time tracker. You can create a timestamp with a start time, end time, customer and a project from this customer. So you can see how much time you've spent for a project or customer. The relationships between tables with "has_many"…
Sebastian Limbach
  • 85
  • 2
  • 9
1 2 3
…
14 15