Query help - Filtering with "Lookup & Relationship" fields

[mike60smart]

Hi



Sorry this appears to have been covered by Davegri

In your Actions table you are still using Lookup Fields for the Status, Priority and Project Fields.
These 3 fields Data Types should be a Number and on the Lookup Property Tab set the Display Control to be a TextBox
Also when you name table they should have a prefix tbl ie tblActions and the PK should be named as for the Table name ie ActionID

[CarlettoFed]

You should also take care to properly manage the various field properties and indexes in tables:

Property

Field size
Required
Indexed

Index

create those related to fields used as secondary keys in relationships
to prevent the entry of any duplicates (see Status field)

[pleopard777]

Please upload your db here. Some won't access files from an external link; some cannot because they say they are at work (I've often wondered, aren't they supposed to be working?). You copy the db, compact it then zip it. See "how to attach files" at the top if you need help.

Database file here : Action_Tracker_Experiment.zip

[CarlettoFed]

But you haven't read the one written in post 17

[mike60smart]

Hi
You have not corrected any of the points highlighted in previous posts?

[mike60smart]

Hi

Here with database amended

[ssanfu]

Here are my modifications. I used my naming convention as well as removing the look ups at the table level.

Also see Microsoft Access Tables: Primary Key Tips and Techniques

[pleopard777]

Learning a lot guys, I thank you all for your help. I'll be uploading the db soon, fixed per this discussion. It's taking me a while but I am studying this hard. Plus I've got a friend at work coaching me a lot. I'm learning to do this the right way, without lookup fields at the table level. Fun stuff ...