Circular Referance

Nov 8, 2005

I have (for this post) 2 tables.

department
====================
pk | d_id
--------------------------
| d_fund
fk1 | d_status_code_id
| d_department
fk2 | d_building_id
fk3 | d_contact_id
fk4 | d_note_id
| d_modified
| d_user

contact
====================
pk | c_id
--------------------------
| c_banner
| c_last_name
| c_first_name
| c_middle_initial
| c_job_title
fk1 | c_department_id
| c_department_text
| c_email
| c_phone
| c_modified
| c_user

As you can see there is a circular reference between them as each need the other's pk to ref a contact and department respectfully.

This will cause a problem during data entry will it not?

And if so, would removing the "req" status on either on remove the issue?

thanks

View Replies


ADVERTISEMENT

Circular Ref??

Jan 10, 2007

Hi all,

I have a query which i'm trying to link to a listbox on a form.
One of the colums i'm trying to get in the listbox is from a lookup.
It should return either "in" or "out" but is returning the number values 1 & 2.

so....
i'm trying to write some criteria in my query that says if=1 then "in" etc

Here's what i've got but i'm getting a circular ref error.
In-Spec / Out of Spec: IIf([In-Spec / Out of Spec]=1,"IN","OUT")

Can anyone help please.

Cheers,
Spinkung. :)

View 1 Replies View Related

Circular References

Jul 12, 2005

circular references caused by alias 'filed name' inquiry definition select list? What should i do

thanks

View 1 Replies View Related

Query Circular Error?

May 29, 2007

Noob! I am building an inventory db. I need a query(s) that uses a Qty available to add inventory added, subtract inventory used and put the final total back into Qty Available. I'd prefer to do in all in one query if possible. Any suggestions?

View 7 Replies View Related

Circular Reference Error

Mar 10, 2008

Hi,

I've created a db I plan on using for pricing out parts, the issue I'm having is that I'm getting a circular reference error.
The way my db is setup is like this Partstbl contains the information for all parts made. Some of these parts can have subassemblies and these parts will also be in the "partstbl". In another table called "Subassemblytbl" I choice the parts from the "parttbl". Parttbl has a one to many relationship with "subassemblytbl" The error happens when I created a query that was to calculate the part cost. This cost would then be displayed in the subassembly subform on my main form. I'm having some difficulty explaining this
if anyone can help I'd really appreciate it

View 5 Replies View Related

Tables :: Is It Appropriate To Have Circular Relationships?

Feb 3, 2014

This is how I have my database set up currently, except the part highlighted in red.

I was asked to see if I can use the CAT (one) to narrow down the CLIN (to many) and this is how I think it should be structured. Is it okay to have this kind of circular relationship within the database?

View 14 Replies View Related

Update Records With A Circular Many To Many Relationship

Feb 27, 2006

Hi Foks,

I'm sure this has been asked and answered many times but I'm not having much success in searching for it as I can't think what to put in the search engine. My apologies in advance for the longwindedness of this posting.

Anyway, I have a database for tracking projects. As the projects evolve, they are sometimes amalgamated, split, dependant on other projects or implemented under a common contract with one or more other projects. Thus, a project can have none-specific relationships with multiple other projects.

To accomodate this:

I have a juction table, tbl_Related_Projects, with fields Project_ID and Related_Project_ID set up as a joint PK.

The PK of tbl_Prj_Details has 1-to-many relationships to both of these fields to create a "circular" many-to-many relationship between the tbl_Prj_Details.Project_ID field and itself.

A comment field in tbl_Related_Projects describes the nature of the relationship between the projects.

;) I hope I you're still with me and following this!;)

On my fdlg_Prj_Details, I have a subform for tbl_Related_Projects. A user can select related projects from a drop down list (Combo Box). So far so good.

Here (finaly :eek: ) is the question: When a user selects a related project (Project B) on the related project subform for Project A, how do I get the reverse relationship to show for Project B i.e. Project A is to appear in the related projects subform of the Project B record, along with the same comment?

I can't even begin to think how to achieve this but as it is a relationship issue, it must be what relational databases are all about and have been solved many times.

Currently a user must select the appropriate project in the related project subform for each record and enter the comment twice. The possibility and liklihood is that the relationship will not always be noted for both ends i.e. A will be related to B, but B not related to A.

:cool: Small caveat for any helpers here, I can copy, cut, paste and stumble/modify code, but at this early stage in my database carreer (ha!), I cannot write it from scratch - too many traps for beginners.

Having re-read this a number of times before posting, it is occuring to me that this is a more complicated problem than I thought it was. Many thanks in advance for any help and advice.

Regards,

Keith.

View 8 Replies View Related

Queries :: Circular Reference Caused By Query?

Jul 23, 2013

I created a query that pulls information from 2 other queries and everything was going fine until I saved the query. I now get a circular reference error

SELECT [CashValue Link Query1].Facility,
[CashValue Link Query1].[Financial Class],
[CashValue Link Query1].Date,
[CashValue Link Query1].Date,
[CashValue Link Query1].[Total A/R],
[CashValue Link Query1].Current,

[code]....

View 1 Replies View Related

DLookup Returning Circular Reference Warning In Control Source

Oct 15, 2015

I'm working on my first report and am trying to get my textbox, tboJob to show a field value and not the ID. I have tried the following Dlookup in my control source with no luck.

Code:
=DLookUp("[JobName]","Jobs","ID=" & [tboJob])

JobName is the field I want to show from the table Jobs.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved