No underlying data to support subform

[Shannan Casteel via AccessMonster.com]

Everyone,

Thanks for your help, using everyones advice, I slowed down, took a look at
the Northwind Sample database, and everything began to click. I set up
relationships, built subforms, and queries, and everything is working fine
now. Sorry I was so stubborn, I was just afraid of going the wrong way for
too long. I didn't think everyone knew exactly what I was trying to do. I'm
done with the parts stuff.

I do have a similar problem though. I now have to do the same thing with job
codes. How could I set up a subform to list job codes without having a
computer file listing all of the possibles. All we have is this big book
that lists all of them. It would take forever to input all that in the
computer. I suspect someone from the company we bought out has a file of
them, but I doubt they'd give it to us. I want to be able to list the
appropriate job codes for each claim along with the hours for each, and then
be able to tally the number of times each has appeared.

I have my main claim table called tblClaim with ClaimID as the pk, this table
has several fields for claim info.
I have another table called tblCodesPerClaim with ClaimID as the foreign key
and CodeID as the pk, and Hours.
The last table is tblCodes with CodeID as the pk, and Hours.

I have a one to many relationship set up between tblClaim and
tblCodesPerClaim, and a one to many relationship between tblCodesPerClaim and
tblCodes.

***The tblCodes table has the two fields in it, but they are blank. I don't
have the necessary data in electronic form to fill this table.

Anyway, Thanks for everyones help, and once again sorry for being so stubborn.
All of you were right.

Shannan Casteel
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[Salad]

Shannan Casteel via AccessMonster.com wrote:

Everyone,

Thanks for your help, using everyones advice, I slowed down, took a look at
the Northwind Sample database, and everything began to click. I set up
relationships, built subforms, and queries, and everything is working fine
now. Sorry I was so stubborn, I was just afraid of going the wrong way for
too long. I didn't think everyone knew exactly what I was trying to do. I'm
done with the parts stuff.

I do have a similar problem though. I now have to do the same thing with job
codes. How could I set up a subform to list job codes without having a
computer file listing all of the possibles. All we have is this big book
that lists all of them. It would take forever to input all that in the
computer. I suspect someone from the company we bought out has a file of
them, but I doubt they'd give it to us. I want to be able to list the
appropriate job codes for each claim along with the hours for each, and then
be able to tally the number of times each has appeared.

I have my main claim table called tblClaim with ClaimID as the pk, this table
has several fields for claim info.
I have another table called tblCodesPerClaim with ClaimID as the foreign key
and CodeID as the pk, and Hours.
The last table is tblCodes with CodeID as the pk, and Hours.

I have a one to many relationship set up between tblClaim and
tblCodesPerClaim, and a one to many relationship between tblCodesPerClaim and
tblCodes.

***The tblCodes table has the two fields in it, but they are blank. I don't
have the necessary data in electronic form to fill this table.

Anyway, Thanks for everyones help, and once again sorry for being so stubborn.
All of you were right.

Shannan Casteel

I suppose you could either input the codes via a combo or text box. Set
the NotInList to update the table if the code is new or when a code is
entered, see if it is new. If so, add a record into to code table. The
reason I mention opening a form is that the table may consist of code
and description. This way you end up with records with the codes that
are used, not those that are unused.

Or you could try OCR and scan the codes in.

[Larry Linson]

"Shannan Casteel" wrote

. . . How could I set up a subform to list job
codes without having a computer file listing
all of the possibles. All we have is this big book
that lists all of them. It would take forever
to input all that in the computer. I suspect
someone from the company we bought out has
a file of them, but I doubt they'd give it to us.
You bought the company? And someone is withholding company property? Sure
sounds illegal to me...
I want to be able to list the appropriate job
codes for each claim along with the hours for
each, and then be able to tally the number of
times each has appeared.

Are you submitting the claims to some organization? Perhaps they have the
file of valid job codes that they would supply you.

Or, perhaps, _whoever_ has it (maybe the publisher of the big book) would be
willing to either sell or license you a copy.

Larry Linson
Microsoft Access MVP