Linking tables in a form

[Mardi Gras]

I have created 5 tables and each has an ID field of auto number. I have
joined the tables using ID# and when I go to show relationship the joining
lines appear.

Problem 1-I have created a form which uses the ID# from table 1 and then
fields from each of the other tables. Form looks good in both views. When I
attempt to enter data in form view the ID# just shows (auto number) and the
information does not appear in the various tables but if I enter in form
database view it will enter ID# correctly

Problem2-On the table design Caption is correctly entered not using
strTitle. On 3 of the fields the str is off like it should be but on 2 it
still shows up

This is my first attempt and I thank you for your help.

 

[Tim Ferguson]

I have created 5 tables and each has an ID field of auto number. I
have joined the tables using ID# and when I go to show relationship
the joining lines appear.

You don't say what you have joined the IDNumber fields to... If it is to
each other then (a) it won't work because you can't control what number
goes into an AN field; and (b) it's really not a sensible design anyway if
you are trying to make five side-by-side one-to-one relationships.

Perhaps you might be able to explain more of what you are actually trying
to model, rather than how?

B Wishes


Tim F