Self Join Table Form Development
The field in the table are:
strID (Primary Key)
I think it will require a two form approach, one to create the employee and one to assign the boss. But I want the boss to be a combo box with only employees that have been created.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I can force an entry into each table - but that seems a bit crude (I.e add a record for every new entry in my main table into the 10 child tables - but this seems to be a waste - I only want to join tables when there is info in them - when I am doing this I can join two tables fine - but adding another one where there is no data FK seems to throw it. I will have about 10-12 tables to join.
I have a left join with criteria on the joining field. The problem is when the tables join on that field, some of the 1st tables rows are being removed by the where clause. I think what's happening is the join is putting the tables together, then removing rows based off of the criteria.
What I would like is the where clause to remove rows from table 2 first, then do the join with table 1 so ALL rows from table one remain.
Table 1 - contains a whole range of names
Table 2 - contains ONLY some of the names ON TABLE 1
I created an inner join between the names on both of these table as I need the amounts from tble 1 with the names of table 2
Is it possible to also get a list of names and amounts from table 1 which DO NOT APPEAR IN TABLE 2
this was code used to find the similar names on tbl 2 with amounts from tbl1
SELECT tbl2name, tbl1Amount
FROM list2 INNER JOIN list1 ON tbl2name = tbl1name;
Employees - primary key empid-autonumber
Products -primary key itemnumber-text
and I have a join table called "transactions" - I use foreigh key for this table.
I created a form, using query builder to bring all records from this two tables into a form but is repeating information. Do I have to filled out "transaction table"
I've done this before only catch is now I need to use a where clause which removes the non-matching rows.
The join works fine and returns the data to my form as expected.
I will summarize in the hope that this is an obvious problem. Please let me know if I need more detail.
Set rs = db.OpenRecordset("SELECT . ")
rs!Blah = frm!txtBlah
The problem is that when I select a value to update that exists in the "right" table, it creates a second entry in the "left" table and never updates the "right" table
Whenever I change the type of the join query from SELECT to MAKE-TABLE, all my SQL statement gets deleted
I have two temporary tables I am putting an INNER JOIN on two columns (both columns are numeric values, but column1 is stored as text). In TABLE1, these two columns identify unique combinations (i.e. could be used as primary key) but in TABLE2 these two columns are not unique. I am performing an inner join and pulling back various other columns from the two tables. I want to know if sorting each temporary table prior to the inner join will speed up the processing, or slow it down.
In other words, will the server acknowledge the fact that the tables have been sorted so it will take each unique two column combination from TABLE1 and only search TABLE2 until it has found the matching records (or it sees it has reached numbers that exceeds itself) and iterate to the next record from TABLE