Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: neszz
  • Order by date
  1. neszz

    AutoNumber

    Leslie, you are right. I read it once already, and thinking about reading it one more time. It is a good tutorial. Niles
  2. neszz

    AutoNumber

    Thanks Richard for everything. Also I like to thank everybody else for posting. As a beginner in Access I have been running into a lot of problems but at the same time figuring them out with your guy's help. I am going to reread this post and revise my project. At the same time, I am also trying...
  3. neszz

    Sorting/Retrieving data on a Form

    Hi! I have a question regarding retrieving recor from a query onto a form. Here are the details what is going on. I am collecting information regarding properties. It contains the property owners information (Name, Phone Number, etc), property information (State, County, City, sqft, etc.), Loan...
  4. neszz

    AutoNumber

    That help a lot. It make it easier for me to understand. I am going to give you more info because my parent table only has one duplicate and that is PropertyId. Here is a link of my relationship table. This make it easier for me to express my situation...
  5. neszz

    AutoNumber

    I have many tables and I am using the graphical tool to link tables. Majority of my Pk's and Fk's should be autonumber because they are all Id's. For example, PropertyId, OwnerId, LoanId (Two or more loans), CostId, etc. I use these Id's to connect to my Property base table. The relationship are...
  6. neszz

    AutoNumber

    I tried to relate one of my PK called Property ID to a link table, which has a FK called Property ID. I receive a message box called, "Invalid field definition 'PropertyId' in definition of index or relationship" the field properties are the same, contain increment and is index but do not allow...
  7. neszz

    AutoNumber

    That makes sense. I have not put my PK ID's to autonumber. My three ID's act like autonumbers that they are just used for incrementing. I thing I do not want, is to have three text boxes (of these PK ID) on my form. I do not want the user to control the number sequence of the three ID's. What do...
  8. neszz

    AutoNumber

    I have a question regarding AutoNumbers. I have a couple of tables that have ID, that I want to be auto-increment. I do not really want to have it on the form but incremented with a value or decremented if the record is deleted. This ID field name is also a PK to relate with other tables. How do...
  9. neszz

    table relationship [having trouble]

    Final: I have a better question to ask then just submitting updates and thoughts. I hope this thread helps other beg. b/c it is helping me out. I have the relationships set up now. I took out the loanholder because the relationship with the table loan was not working out when I was doing some...
  10. neszz

    table relationship [having trouble]

    [Update:5] I made it relate by changing the loan_num field properties. Now, I am adding all the tables into a query and onto the form. It says that I cannot add or change a record because a related record is required in the table Loan_tbl1. I not sure what is needs, I guess place the PropertyId...
  11. neszz

    table relationship [having trouble]

    [New] Table: County_tbl Field Name: County (PK) ? I already input the county into the table, so user can just use the combo box to access which county the user wants to pick. Table: Loaninfo_tbl1 Field Name: Total_Interest_Owed Total_PrePayments Cash_To_Owner Assignment_Fee...
  12. neszz

    table relationship [having trouble]

    Thanks, I printed the article. I split the table because I thought you suggested it. All I am doing is tracking properties and their owners. Later on I want to track the dates of the properties being sold. I just to get moving on this project, due in 2 weeks. I will keep you updated. Thanks...
  13. neszz

    table relationship [having trouble]

    John: This is what I produced from what you are saying. Table: County_tbl Field Name: County (PK) ? I already input the county into the table, so user can just use the combo box to access which county the user wants to pick. Table: Loaninfo_tbl1 Field Name: Total_Interest_Owed...
  14. neszz

    table relationship [having trouble]

    This is what I got so far from the post. Let me know if there is something is missing. Parent Table: Property Child Table: Subordinate to Property-tbl Loan- I think what you said is how many and then have a child parent which is subordinate to this table (loan), would be the Loan Holder...
  15. neszz

    table relationship [having trouble]

    Thanks John. I am going to try this out. After doing this, I add all the tables into one query in order to sort by counties, then cities, and etc. I know I am getting ahead of myself, but after doing the tables relationship and query, I drag the tables into the form, in order for the end user...
  16. neszz

    table relationship [having trouble]

    So you are saying that Loan should be the Parent table-which retail and backgound info, be placed into the loan table a field names, is this correct? The reason I wanted the county to be the parent because on the form it is a drop down menu with the counties, then the rest is data entry of the...
  17. neszz

    table relationship [having trouble]

    I have a question regarding relationships between tables (Parent to its child tables). Here is my situation of this Access 2002 database program. Introduction: I am creating a form for people to enter in properties for my project at school. I want people to be able to select a county that...

Part and Inventory Search

Back
Top