Linking Multiple Tables with queries to create a workable form

[Guest]

I have read different posts on the subject with a multitude of responses and
have tried various approaches. I have four tables.

Employees Junction Tbl Record review Tbl Use of Force Tbl
SSN Key TableJ ID Key Table R ID Key Table ID
UOF Key
Last_N SSN (Number) TableJ (Number) 1st Qrt Update
Title Table UOF (Number) 2nd
Qrt Update
1st Qrt Update ect..
3Rd Qrt Update


All tabels are linked (one to Many)/ Ref Integrity Enforced / Cascade Update
and Delete checked
Example: SSN key - SSN Number / Table J key- Tbale J (Num) / TableUOF (Num)
- UOF Key

I am attempting to create an updatable form containig SSN-LName-Title from
(EmployeeTbl) 1st thru 4th Qtr Update from (Record Review Tbl) and 1st thru
4th Qtr Update from (UOF Table).

I have run a Query with all fields desired and get no values returned. I
attempted to adjust the table join function and get the values to show but
the query is not updatable or I get SQL could not exe because of ambiguious
outer joins.

I then have attempted to join the Record reviewTbl and UOFTbl in a seperate
query I then included that query with a new query which included the employee
table but I still end up with the same problems in retrieving the data.

I think I have become lost in the sauce.

Any Ideas??

Thank you in advance because I understand the importance of your time

 

[John Vinson]

I am attempting to create an updatable form containig SSN-LName-Title from
(EmployeeTbl) 1st thru 4th Qtr Update from (Record Review Tbl) and 1st thru
4th Qtr Update from (UOF Table).

That's the wrong way to go about it.

Instead of creating One Big Master Query and basing a simple form on a
complex query... create a more complex form, based on simple queries.

Use a Form based on EmployeeTbl, and use Subforms (using the SSN as
the master/child link field) for the Record Review Tbl and the UOF
table.


John W. Vinson[MVP]