Linking list for enemys

  • Thread starter Thread starter Praetorian269
  • Start date Start date
I have setup 2 tables

InmateInfotbl:
AutoNumber
ControlID
InmateName

EnemyDatatbl:
ControlID
EnemyName

I have it working. In the main form I have InmateInfotbl and in the subform
I have the EnemyDatatbl. Works great however I was hoping that there was a
way that when I add the information in the subform it would automatically
add it to the InmateInfotbl as a seperate record. This way I could do a
search in the InmateInfotbl and it would pull all the records relating to
that inmate.
Click to expand...

Look at my suggestion, and Phil's and Arvin's again. Given that an
"Enemy" is also an "Inmate" (at least I assume so) there should NOT BE
a name in the EnemyDatatbl, just a link back to the InmateInfotbl.
Would it be easier if I posted it so others could see what I was working on?
Click to expand...

No. Posting binaries in these text newsgroups is strongly discouraged.
 
Praetorian269 said:
I work at a County Sheriff Department simply asking for assistance in
creating a classification
program for our classification officer.

Since you teach at your local community college, you should know that the
budgets of County
Departments do not provide enough funds to have programs written for them in
every aspect of
the job that they need.

I thought that this was a place to ask your questions, instead I get
ridiculed for asking a question outside of the realm of my expertise.
Click to expand...
(snip)


Hi, Joe. Certainly I was not trying to have a go at you. The opportunity to
make the joke that I made, just seemed to good too pass up!

Ask away & I'm sure that everyone will help answer your questions.

TC
 
If you'll give us a little more detail of what you have and what you want to
do, maybe we can get past the off-topic stuff and get on with trying to help
you, Joe.

Form with subform, but you have to _do this_ for each inmate you add? Do
_what_? If you are creating a separate form for each inmate, then that is
clearly unnecessary work -- please clarify.

Larry Linson
Microsoft Access MVP
 
Back
Top