By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,501 Members | 831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,501 IT Pros & Developers. It's quick & easy.

Inserts via query on 1-to-1 relationship

P: n/a
Suppose we've got 2 tables A & B; A contains a code field which is a foreign
key for the lookup table B. B has a primary key containing the codes and
another field with the fulltext equivalent for each code. Thus there's a
1-to-many relationship between B and A. If we set up a query on the join of
A and B, we can insert a new record and as soon as the code field is filled
in in A, the corresponding fulltext value in B appears automatically in the
appropriate field.

Now do a similar thing with tables C and D, but relate them 1-to-1. So C and
D have the same primary key field, but no foreign key link. Set up a query
joining C and D. Start inserting data into a new record by entering the key
field in C, tab to the next field, and it would seem reasonable to expect
the fulltext field from D to fill in as before, BUT IT DOESN'T.

Is this a facility of 1-to-1 relationships, or have I omitted some vital
step. I thought setting up referential integrity in the Relationships window
with D defined as the 'parent' table might do the trick, but no joy.

Any ideas?

************************************************** **********************
Dave Stone e-mail: D.*****
Computing Services Telephone: +44 131-650-3314
University of Edinburgh Internal ext: 503314
Main Library, George Square FAX: 0131-650-3308
Edinburgh EH8 9LJ
************************************************** **********************
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.