Search results for query: *

Well shucks. It is a project for an intro class, but I'm adopting a work project so it's much more complicated.

I tried basing it on a query and then I can't see the college field for the other data already in the query. Ref integrity is enforced. I've broken the relation and re-established a number of times, playing with the direction using a junction table. Even re-reading the reference papers that...

I created a form based on two tables, Contacts and Colleges. I want to add contacts to contacts table using all the fields in the form and included only one field from the college, college name. I have the College ID number in the contact table to link the two. I get an error message upon...

Ok - I'll start tomorrow. Thanks for the posting etiquette tip.

Thanks for the reference, fneily! I'll pore over it tonight and see how far I get.

Lilliabeth, I realize what the data entry property does - but I can't figure out how to create the form so it doesn't automatically choose the property setting. It could be in the table set up/relation/or form set up. So many opportunities for error - so little time to get it right.

Back to the parent/child thing. All I want is to show the college name in a form where I will be entering new contacts. Perhaps the problem lies with only having the college id in the contacts table. I don't really need to populate the contacts table with the college name, I only want to see...

And another thing... I read that in the junction table you identify all three as a primary. Is that correct? Thanks again.

The second dialog box. When you are pushing over the fields to the Want side (for lack of a better term) you can select a different table (there is a drop down list) and the fields from that table show up for you to choose.

If you are not suppose to use more than one table in a form, why is the capability to do so there? I am also having a similar problem and I read somewhere that it might be a read-only form. The allow additions was set to no. When you change it to yes, you can no longer see the rest of the data.

What I want to know is: 1. How do you form the relationships? Primary table to junction, and then junction to related table? Or just a one to one on the joining to the related? 2. Also does this create more indexes? If done properly, this should allow you to enter new scanners, computers...