Search results

  1. J

    Select Query not showing all records.

    The database works the other way around as you have stated, one Customer can have/be associated with many Properties, or many Properties can fall under one Contract. Does this help? John
  2. J

    Select Query not showing all records.

    jdraw, Yes your assumption is correct. For example, given record in the tblProperty table may not have a “Property Type” so the corresponding PropertyTypeID FK in the tblProperty table would be blank. Having said this back to my original issue, when I created the query any record with any...
  3. J

    Select Query not showing all records.

    Bryan, Let me clarify the way I setup this database. Referencing the Relationship image from the post above, with the exception of the tblAudit table all of the others represent a list of option available to the user. And that selection is associated to the tblProperty table via the one-to-many...
  4. J

    Select Query not showing all records.

    Yes I do (see attached Relationship).... If this not correct please let me know and could you provide a referance that i can read to obtain the correct process.... John
  5. J

    Select Query not showing all records.

    I have a table “tblProperty” with multiple fields; some text and some number fields along with number fields representing FK, the number fields are things like “pages” and “copies”. I have created a query containing the table described above and the associated tables for each FK. When I drop...
  6. J

    Help with VBA code accociated combo box

    jz, Yes, I can receive a USPS Express containing one or more pieces of material (e.g. CD/DVD’s, Documents ECT) in any combination. The same is true if I am sending material. Not to put a monkey wrench into this but, I could receive a given piece of material on one day and send the same piece...
  7. J

    Help with VBA code accociated combo box

    Jz, Thanks for your advice, I agree with your assessment of the tblSentDetails and tblReceivedDetails and have combined them see Relationship2 image showing related tables. However I did leave the organization and carrier tables separate, I did rename the carrier to mailcarrier. The reason being...
  8. J

    Help with getting an unbound combo box in a form to do what I want.

    I have an issue with getting an unbound combo box in a form to do what I want. I have originally posted in the Modules & VBA thread but have not gotten any “hits”. Below is the link to that post with details. http://www.access-programmers.co.uk/forums/showthread.php?t=227618 Thanks John
  9. J

    Help with VBA code accociated combo box

    Hello All, I have an issue I am trying to resolve, I have a possible method to resolve this issue but I need help with the possible code. Also, if there is a better way to go about solving the issue please let me know. Background: I am using Access 2007; if you look at the attached Relationship...
  10. J

    Help with Tables and NF

    Pat, Attached is relationship #4 and I have included the section from the FAR clause that identifies the minimum information required to be maintained by the property manager. As per you advice I have put all of the things I believe belong with the PropertyDetail table I have renamed a couple...
  11. J

    Help with Tables and NF

    All, Sorry about not being able to upload the original database. I can send it via email if you are interested. Also attached is the .pdf of my second pass at normalizing. John
  12. J

    Help with Tables and NF

    All, As stated above attached is the working Government Property database. There are parts of the database I did not talk about before, like the Audit part. There is a requirement to maintain audit history. The way I have implemented the auditing is as follows: Create an audit form by...
  13. J

    Help with Tables and NF

    Pat, If you think it would help, I actually have a working Government Furnished Equipment database now. I created this database before I started taking a hard look at database development (outside of Access). This database was created before I started looking into Normal Forms and normalization...
  14. J

    Help with Tables and NF

    Thanks All, I am sorry for any “face planting” done on my behalf. To answer a top level question, yes it is a complex and convoluted process. Part of the problem is I am dealing with the government and some of their processes don’t lend themselves to straight forward answers. I will try to...
  15. J

    Help with Tables and NF

    Spike, No problem, sometimes it is difficult to remember not everyone knows what you do on a given subject. Government Furnish Equipment/Property (GFE/P) is a term used to identify equipment and/or property obtained either directly by signed receipt or indirectly by ordering the item using...
  16. J

    Help with Tables and NF

    Pat/Spike, I have made some changes to the structure as you pointed out. I will have to think a bit more about the Contracts and Customer issue. I agree the name “Master” was misleading, I have changed it to “Item” and I have merged the old items table into the new re-named “Item” table...
  17. J

    Help with Tables and NF

    Spike, Sorry for the lack of information, see the .jpg below. I have changed some of the row information to make it flow better. The ProtoType table is there to provide a predetermined list of property types. The ItemLocation table is the physical location of the item. The Customer table is a...
  18. J

    Help with Tables and NF

    Hello All, Not sure if this belongs here or in the Theories thread. Need some help/advice on the Normal Form/Normalization process as it relates to the tables shown in the .pdf below. I believe I have it down pretty good (I may be wrong); there are two things I need help with. First in the...
  19. J

    Possible Query Quandary

    Thanks Pat, I was able to do as you sugjested, i did end up making select querys for the problem children on my form. I am using Acess 2007 and it does seem to be buggy at times... Thanks again John
  20. J

    Possible Query Quandary

    If it helps attached is my current Relationship screen. You can see i have the tblOrganizatio and the _1 and _2. John
Back
Top Bottom