why can't i enter data in a form when it's in a relationship?

[Guest]

I have created a data entry form that enters data from a few different
tables. the basic structure is Alumni with several attributes including SSN.
also, email, homephone and work phone are multivariable, so i've put them in
seperate tables with primary key SSN and then the respective field. so for
example, HomePhone has two attributes, SSN and homephone, with a concatinated
primary key and if ther eis more than one number, than i just enter in a
social with another phone number. same thing with email and work phone. i do
have the relationships setup to link the SSN in each table to the SSN in the
Alum table which is the primary table of information. However, when i get my
form created, it wont' let me enter any data. no error message, just the
little ding noise. i dont know what to do. i've read a lot of other posts but
nothing seems to apply to this situation. some help is greatly appreciated!

 

[JohnFol]

I presume the form is based on a query that links the tables together. What
is the structure of the query?

 

[Rick B]

If all the tables are a one-to-one relationship, I think you can do it. You
indicate that you have one-to-many relationships on your phone number. This
would need to be in a sub form on your form. How could access update this
if you have two phone numbers in a table that match the current record, but
you only have one field in your form?

Rick B

 

[Guest]

yes, access has it set as a one to many. and i suppose i'm not very familiar
with sub form structure. does each table need to be a subform? in response to
johnfol, it's not based on a query. the form is simply data entry to the
tables. it isn't even used for updates. so the form is blank and i try to
enter data. but nothing? IF there are multiple phone numbers, there is a
seperate form that allows for the entry of an ADDITIONAL phone number or
email, but this form simply enters in the data if there is only one. make
sense? how do i do subforms, and how do they work?

 

[Guest]

LT,

I truly hope you are not using Social Security Numbers (SSN's) as a primary
key in your database. If you are - please reconsider.

Karrie

 

[Rick B]

It is hard to describe here. You might look at the Northwinds sample
database and check out the form "Orders". It allows you to add an order
(main form) and add lines to the order (maybe one, maybe more) in the
subform.

In your case, the form would be for the personal data, and the subform would
be for the phone numbers or any other table where a 1-to-m relationship
exists.

Post back if you need more.

Rick B