access table field question

[RuralGuy]

BTW here's a pretty good breakdown for Normalization on this forum.

[simplerequest]

reviewing

i see the change you made on the form with the combo box

but i dont see how this works for the table there is not facility number on the table i will need that

[RuralGuy]

You have the FacID in the table. With that you can always get the facility number with a join. That is the beauty and the power of queries and joins. It is as if all of the related tables are just one big table.

[RuralGuy]

Open the qryRecReport directly. Don't you see the values you need in there?

[simplerequest]

falling asleep will read the normalization tomrrow. can we meet again tomorrow?

[RuralGuy]

If you have no more questions for right now then I'll toddle off to bed. We can hit it again in the morning. Just post and we'll hook up.

[simplerequest]

only opened the two tables went back and looked at the querry
thanks the form is working

can i get back to your tomorrow, will you be willing to assist again i can not keep my eyes open

[RuralGuy]

Whenever you want to start just post a question here.

[NeoPa]

Here's a link you need to read: The Evils of Lookup Fields in Tables

That's nice to see. I thought it must be the 'right' way to do things, but it's only ever led to problems for any databases I've ever had to review.

Thanks for the link RG :)

[RuralGuy]

You and almost everyone that uses them. You're welcome.

[FishVal]

Here's a link you need to read: The Evils of Lookup Fields in Tables

Unfortunately it doesn't have a part "The Goods of Lookup Fields in Tables".
Obviously, it was dropped to not to spoil the impression.

Does anybody like to discuss it in a separate thread?

[RuralGuy]

Start a new thread ans see who joins.

[FishVal]

Actually, I don't even see what to discuss there.
All points of that article are weak, inconsistent and arguable. At the same time I have no idea what to add against "lookup fields". This makes me feel it will be a discussion of trivial things.

[NeoPa]

Does anybody like to discuss it in a separate thread?

Actually, I don't even see what to discuss there.

Now I'm really confused :S

[RuralGuy]

I don't think you are alone NeoPa.