yessir
Saved By Grace
- Local time
- Today, 03:44
- Joined
- May 29, 2003
- Messages
- 349
I have (for this post) 2 tables.
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
Code:
department
====================
[B]pk | d_id
--------------------------
| d_fund
fk1 | d_status_code_id
| d_department
fk2 | d_building_id[/B]
fk3 | d_contact_id
fk4 | d_note_id
[B] | d_modified
| d_user[/B]
contact
====================
[B]pk | c_id
--------------------------
| c_banner
| c_last_name
| c_first_name
| c_middle_initial[/B]
| c_job_title
[B]fk1 | c_department_id[/B]
| c_department_text
[B] | c_email
| c_phone
| c_modified
| c_user[/B]
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
Last edited: