Re: How to keep id number though each table

Yes you are correct on both accounts. Sorry for not getting back sooner


"Lynn Trapp" wrote:

> So may I assume that IDNumber is the primary key for for the first table? Or
> is idNum the primary key for the other tables or do you have another field
> defined as the primary key?
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
>
>
> "pokdbz" <pokdbz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:7399A743-BC80-486E-859C-0390D57D3C92@xxxxxxxxxxxxxxxx
> > Ok, Here is what I have for each table. The first table has a field
> > IdNumber
> > and some other fields this is the table where the IdNumber is entered and
> > this value has to be used in every table. All of the other tables have a
> > field idNum and some other fields.
> >
> > So is this all that you needed? If there is anything else you need let me
> > know.
> >
> > "Lynn Trapp" wrote:
> >
> >> You may not have a relationship defined, but relationships have to exist
> >> (in
> >> one form or another) to accomplish what you want. I can't help you if you
> >> won't post your table structure.
> >>
> >> --
> >> Lynn Trapp
> >> MS Access MVP
> >> www.ltcomputerdesigns.com
> >> Access Security: www.ltcomputerdesigns.com/Security.htm
> >> Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
> >>
> >>
> >> "pokdbz" <pokdbz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:42E4799B-441A-40E1-B323-CF6B5C941A0F@xxxxxxxxxxxxxxxx
> >> >I don't have any relationships defined. I don't need any. It is just a
> >> > single entry into each table for each person. Just need the IdNumber
> >> > off
> >> > of
> >> > the first form to go into every Table.
> >> >
> >> >
> >> > "Lynn Trapp" wrote:
> >> >
> >> >> Let's take a step backward. Could you post the structure of your two
> >> >> tables?
> >> >> What relationship exists between the tables? One to Many or One to
> >> >> One?
> >> >>
> >> >> --
> >> >> Lynn Trapp
> >> >> MS Access MVP
> >> >> www.ltcomputerdesigns.com
> >> >> Access Security: www.ltcomputerdesigns.com/Security.htm
> >> >> Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
> >> >>
> >> >>
> >> >> "pokdbz" <pokdbz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> news:55FBE4B4-013E-4B6D-B56A-1B6D2E36D0EA@xxxxxxxxxxxxxxxx
> >> >> >I made a subform on the 2nd table where i want the IDnumber to go.
> >> >> >That
> >> >> > seems to be pulling the number from the 1st form. But how do I
> >> >> > actually
> >> >> > get
> >> >> > it so save in the table that is assigned to the 2nd forum?
> >> >> >
> >> >> > Am I going about this the right way?
> >> >> > Could you give some instructions on what to do?
> >> >> >
> >> >> > "Lynn Trapp" wrote:
> >> >> >
> >> >> >> 1. Create a form based on the second table. Be sure to include the
> >> >> >> IDNumber
> >> >> >> in the record source of the form.
> >> >> >> 2. Create a form based on the first table, that also includes the
> >> >> >> ID
> >> >> >> number
> >> >> >> 3. Place a sub-form control on your second form and make sure the
> >> >> >> 2
> >> >> >> forms
> >> >> >> use the IDNumber as the Master-child link fields.
> >> >> >>
> >> >> >> --
> >> >> >> Lynn Trapp
> >> >> >> MS Access MVP
> >> >> >> www.ltcomputerdesigns.com
> >> >> >> Access Security: www.ltcomputerdesigns.com/Security.htm
> >> >> >> Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
> >> >> >>
> >> >> >>
> >> >> >> "pokdbz" <pokdbz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> >> news:65AE72A7-3995-4EAF-8B86-D06E61BC1FE8@xxxxxxxxxxxxxxxx
> >> >> >> >I have my first table with an IdNumber as a field that is input.
> >> >> >> > Then I have another table with questions that the IdNumber
> >> >> >> > answered
> >> >> >> > how
> >> >> >> > do
> >> >> >> > I
> >> >> >> > get that same IdNumber into the 2nd table so I know what IdNumber
> >> >> >> > the
> >> >> >> > data
> >> >> >> > goes with.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
.

Relevant Pages
Loading