Topics Search

Self Join Table Form Development

Self Join Table Form Development
Views: 12
I have a table with a field that relies on another field in the same table. Very much like the Employee/Boss table design that is used for self join examples. I have developed the tableand query but do not know how to make the form that would support the table design.

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.
Sponsored Links:

Similar posts...


Left Join That Includes Null values on Right Table, Even If Match Found

Left Join That Includes Null values on Right Table, Even If Match Found Icon
I then have a table of answers for those questions. Each user gets the entire list of questions in a continuous form. I would like to join the answers table to the questions table. Here is my join statement.

10 plus tables to join

10 plus tables to join Icon
I have 10 + tables that I need to join together Easy when they have info in them, but sometimes info will only be in 1 table or 2,3,4 etc.

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.

WHERE as part of JOIN not after

WHERE as part of JOIN not after Icon
I am stuck on a JOIN problem that I can't see to work around.

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.

How to join different fields from same table

How to join different fields from same table Icon
Is it possible to join different fields from the same table?

RootCause, SubCatA, SubCatB
RootCause2, SubCat2A, SubCat2B
RootCause3, SubCat3A, SubCat3B

They all contain similar data. In the form, chocies for sub cat is populated based on the root cause selection

join table

join table Icon
I have two tables
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"

inner join question

inner join question Icon
I have two tables with names and amounts

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;

Implementing the Equivalent of a FULL OUTER JOIN in Microsoft Access

Implementing the Equivalent of a FULL OUTER JOIN in Microsoft Access Icon
There are many different kinds of joins, like INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN. The first three of these different join types are implemented in Access, but FULL OUTER JOIN is not. If you need to perform a FULL OUTER JOIN in Access, are you "up a creek, without a paddle"? No, you are not. This article will show you how you can write some SQL code in Access to implement a simulated FULL OUTER JOIN.

Update with LEFT JOIN

Update with LEFT JOIN Icon
I've been trying to figure out how to use VB to create a LEFT JOIN and perform an update on the results of the query.
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

SQL Left Join

SQL Left Join Icon
I have a master table with 6 rows in it. Id like to run a query that would grab all those rows, then join a join table with it. Regardless if theres a match, I want all 7 rows from the master to display.

I've done this before only catch is now I need to use a where clause which removes the non-matching rows.

Make-table query out of join query

Make-table query out of join query Icon
Is it possible to create a make-table query out of a join query? If yes, how do I incorporate the INTO statement in my join query?
Whenever I change the type of the join query from SELECT to MAKE-TABLE, all my SQL statement gets deleted