Creating a form

  • Thread starter Thread starter jt
  • Start date Start date
J

jt

Hello, I am trying to create a data entry form that is
based on three different tables. These three tables are
linked with an ID number. I created this form with one
main form (the one side of the relationship) and two
subforms(the many side of the relationship). The problem
is that when I try to enter data into this form I have to
enter that ID number 3 times in order for that record to
be saved. My subforms are linked to the main form by the
ID number (link child fields/master fields) but I still
cannot enter the number only once. Is there anything that
I could do to avoid that?

Thank you!!!
 
Well if it is all setup correctly, you don't need the ID on the 2 subforms.
And remember you only should be entering the ID on the main form when you
are adding a new record otherwise you use the Record Selectors to go to the
different records. If the ID is an Autonumber then you don't even need it
on the main form.
 
Thank you for your response! The problem is that it
doesn't work. I get this message everytime I try to save
the record saying something like there is no field linking
this table to that table when infact there is a link. Also
I get this message saying that the primary key cannot
contain a null value, even though I have entered an ID
number in the one main table. Is there anything else that
could be wrong?

Thanks!
 
Well that is why I started with "If everything is setup correctly"...I guess
it isn't since you are getting those errors. It is really had to tell what
is going on here. Can you put you db on a website to download?
 
Hello, thanks again for responding! I actually created
autonumbers for my id's and it seemed to solve the problem
so I don't have to enter ID numbers every time.

Thanks!!!
 
Back
Top