Inter MDB Dependencies
Mar 27, 20061.Can we have two table in two MDBs with a foreign Key Relationship.
2.Can we Rollback in Access
ADVERTISEMENT
Querying Two Inter-related Field In A Table
Jun 16, 2005Hi,
Need some help. Here's the problem:-
I've two fields in a table (A & B)
A B
1 Null
2 Null
3 1
4 2
5 3
6 5
7 Null
8 4
9 6
The fields are somehow related where values of B (unique) is taken from A(unique).
I trying to do an SQL such that if I input a single value A=9 or 6 or 5 or 3 or 1, the following should be the output:
A B
9 6
6 5
5 3
3 1
1 Null
Or in another case where I input a single value A=8 or 4 or 2
the following should be the output:
A B
8 4
4 2
2 Null
How can I do that? Many thanks in advance!! :D
Odd Dependencies Question
Nov 16, 2006I've got several queries, forms and reports in my database, and I've just noticed that when I look at Object Dependencies, 3 of the queries appear to be depending on the wrong forms. However when I check the SQL of each of these queries, the code definitely is referring to the correct forms.
However can this be and how do I sort it out? All I can think is that when I created these queries originally, I did do a copy and paste from another query and then manually editted the SQL to refer to correct form. Would this cause something to get missed?
Thanks.
Report That Shows Query Dependencies
Jan 8, 2012I have a database that reuses many queries in several different macro's. Any way to generate a report, (or purchase an add-in), that will show for each query any other queries that use it. It would be ideal to show all of the "cascading" queries that one query is built on. It just gets confusing when I need to tweak a query to then have to figure out there are other queries that use the one that's being tweaked and the tweak will change the results of the other queries.
View 3 Replies View Related